Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Move and Copy Pivot Table and Source Data
Using Windows XP Excel 2003, I want to move and copy a pivot table and its'
source data from it's original file into a new file. The issue is that once I get it moved over, the pivot table still shows that it is linked to the orginial source file. I have used the wizard and highlighted the new source data but when I try to proceeed it tells me the pivot table name is not valid. I have tried naming the source data through InsertNameDefine but I get the same message. Any help would be appreciated. Thanks, Lance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table source data | Excel Discussion (Misc queries) | |||
Pivot Table Data Source | Excel Discussion (Misc queries) | |||
copy pivot table and source from workbook 1 to 2. | Excel Discussion (Misc queries) | |||
Pivot Table data source | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |