Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I refresh Pivot Table from an external source ?
I have a Pivot Table in the workbook A, and then a table in workbook B, that
is updated once a month. I then make a Pivot Table in wbk B, based on the base table, then copy the Pivot Table from wbk B to wbk A, replacing the old one in wbk A. I need to be able to refresh PT in wbk A without replacing it, because links to many other tables in wbk A get lost. I tried to go to : Data Pivot Table and Pivot Charts Report hit Back twice Select External Data source, hit Next Get Data Excel Files * select the file But I don't get the options to select the tables or the fields, moreover I get an error something like "this is not an excel file" or "no tables were found". Please help! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selected Columns to be Used in External Data Source in Pivot Table | Excel Discussion (Misc queries) | |||
DATE FORMAT IN PIVOT TABLE FROM EXTERNAL DATA SOURCE | Excel Discussion (Misc queries) | |||
Pivot Table Data Source external excel file | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
Determine the location of an external source of pivot table? | Excel Worksheet Functions |