Reduce the file size of Excel

Posted by Ram on Stack Overflow See other posts from Stack Overflow or by Ram
Published on 2010-06-09T05:48:55Z Indexed on 2010/06/09 5:52 UTC
Read the original article Hit count: 192

Filed under:

Hi,

I'm working in an excel application and providing a menu to the user to add a new worksheet in that excel application (Excel Workbook). The worksheet will be added once the user clicks the "OK" button and I'm using a template to add this worksheet (The template has lot of formatting and formulas in it)

Lets say the file size is 10 MB after adding a worksheet if the workbook is saved. Then I close the Excel application and reopen it and save the file then the file size is getting reduced to 8 MB.

Can anybody let me know what could be the reason for the same?

Thanks, Ram

© Stack Overflow or respective owner

Related posts about excel-vba