Hi,

I have a excel file and the capacity of the file is 129 MB and after
compressing it is aorund 18 MB. Even it is very difficult to handle the file.
I have 7 sheets in the file,

1st sheet is base data and it contains data's of almost 20000 rows and 120
Cols. based on this sheet i have created 6 Pivots in 6 different sheets.

Can anybody suggest me how to reduce the file capacity. Do we have any
option in pivots to reduce the file size. Request you to help in this.
Waiting for your earliest reply.

Regards,
Christopher