Compact Excel file?
Posted on 2011-03-01
I've got an Excel file which contains a couple of macros (several hundred lines of code) which is 6Meg in size.
This is a template that I use to export data from a production database into on a monthly basis, but there are currently about 10 worksheets, most of which have less than 20 cells with data or formatting. The two main worksheets will contain about 300 rows by 30 columns of data each month, but they are currently empty.
I cannot figure out why this spreadsheet is so large, or how to shrink (compact) it down to a reasonable size.