Hello

We are generating excel(xlsx) and zipping it up on an application where users download and save the excel.

The issue is that when Users unzip the excel the file size is say 100 KB. If they save the file, without any other changes to it, the file size increases a lot.

Is this a known issue?

• Edited by MituD Thursday, May 07, 2015 8:08 PM
• Moved by Fei XueMicrosoft contingent staff Friday, May 08, 2015 2:01 AM

Hi Mitud,

Which Excel version do you and users use?  Please try the following steps and check if they are helpful.

First check to see if there is excess formatting in the worksheet(s).
On each worksheet do Ctrl+End.
If the cell selected is way beyond the end of the data, select the entire rows between the actual end of the data and the Ctrl+End cell and delete them.  Similarly delete entire columns between the actual end of the data and the Ctrl+End cell.  Then save the workbook and check its size.

If that's not it, perhaps you have queried a large amount of external data to feed a pivot table.
By default that will be cached in a hidden data structure within the workbook and can increase its size.
I don't know which version of Excel you are using (always helps if you say!). For 2010, right-click the pivot table > Pivot table options > Data > uncheck save source data with file.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support