How to reduce size of pivot

T

Tewari

I have a pivot table and it size is very large say 50 MB and it uses an
access database which is 300 MB to create it.Is there any better way of
doing it?As I really want to reduce the size of pivot.
 
K

Ken Wright

Do you really need to interrogate all the data you are, or can you restrict
it wrt columns or fields etc.

Do you have multiple Pivot tables, and if so have you based them on an
existing pivot table, as this could make a significant difference to your
file size. Example, when you create a Pivot table, it will be far more
fficient if you then copy the worksheet and then just edit the Pivot table as
opposed to creating from scratch and not linking to an existing table.
 
L

Lori

Try unchecking the PivotTable option: Save data with table layout.
This means the data behind the pivot is not saved with the file and can
dramatically reduce file size
 
T

Tewari

I can not reduce /restrict any of the data fields .
I was thinking at another alternative.Is it possible to create a data
cube and then create pivots from these?Will it reduce the size?Any
documentation on cubes and pivot?
Thanks
 
Top