Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
OS: Windows XP
App: Office 2002 Pro. SP2 Hello Every time I create an additional Pivot Table and Save the Workbook it increases the Workbook's size substantially. Is it possible to display a Pivot table's underlying data? I can update the Pivot Table from is original source which suggests that a separate dataset has been created specifically for the Pivot Table. I ask because a user has a 140MB XLS with 20 Pivot Tables pointing to an external data source (another XLS). When all the Pivot Tables are deleted the XLS shrinks to 300K in size. Regards Mike |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need to create multiple Pivot tables at once | Excel Discussion (Misc queries) | |||
#REF in Sheets that refer to Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) |