Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table in separate workbook
Hello,
I have a workbook that contains pivot tables that has become too big and I would like to move the pivot tables to another workbook. When I move the sheets containing the pivot tables to a new workbook, at first everything works fine, e.g., I can make changes to the data on the original workbook then switch over to the new workbook with pivot tables and update data, etc. However, when I save, close, then reopen, I get an error that the new pivot table is not valid. Is it possible to have pivot tables stored in a separate workbook? Any help would be very much appreciated. |
#2
|
|||
|
|||
You can have the pivot table in a separate workbook. If you cut it from
one workbook, and pasted it into another, open the original workbook when you open the pivot table workbook, and you won't see the error message. Or, you can create a pivot table based on an external source, and select another Excel workbook as the source. Then, it won't need to be open when you're working on the pivot table. ehale wrote: Hello, I have a workbook that contains pivot tables that has become too big and I would like to move the pivot tables to another workbook. When I move the sheets containing the pivot tables to a new workbook, at first everything works fine, e.g., I can make changes to the data on the original workbook then switch over to the new workbook with pivot tables and update data, etc. However, when I save, close, then reopen, I get an error that the new pivot table is not valid. Is it possible to have pivot tables stored in a separate workbook? Any help would be very much appreciated. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
Problem making versions of a table by changing sourse data in another workbook | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Pivot table refresh | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |