Thread: Pivot Tables
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Faulkner Mike Faulkner is offline
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