Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 6
Default Pivot Tables

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create multiple Pivot tables at once havocdragon Excel Discussion (Misc queries) 3 July 27th 06 11:16 PM
#REF in Sheets that refer to Pivot Tables Will C. Excel Discussion (Misc queries) 1 June 2nd 06 08:54 PM
Refreshing Pivot Tables linked to Oracle Datasource [email protected] Excel Discussion (Misc queries) 0 April 25th 06 12:15 AM
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM


All times are GMT +1. The time now is 07:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"