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.