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
|