Pivot Tables - File Capacity

[M Imran Buhary]

I have a excel file a fairly large database in one sheet and another sheet
for pivot tables from that databse. once the pivot tables are loaded the
capacity jumps from a mere 175 or 200 kb to 9 or 10 mb. and gives me
difficulties in saving the file in network drives. how can i keep the file to
low capacity and also keep the pivot tables information. I refresh the Pivot
tables only once a week and the result stays as it is till the next week.

 

[splot!]

I used to have a similar problem. The answer, as I see it, is to
recognise that the sheet with the database in it shoudl be in a
database, not a spreadsheet. I put all my data in Access and the
Excel pivot tables now interrogate the Access data.

This also enables a lot more flexibility with data selection.

Regards

Chris