I have an Excel spreadsheet which is pretty much just a template sheet with no actual data populated. The template isn't that large. Cells known and intended to be populated with either text (no formulas any more) or formatting range as follows:
- Sheet 1 - A1:C19
- Sheet 2 - A1:K8
- Sheet 3 - A1:E6
The latter two ranges are formatted as tables.
I wouldn't think this should be a very large file, but the file's size is over 5 MB.
At one point, it was over 10 MB. Then, I found that I'd populated a formula down an entire column. Once I deleted the formula entirely (it was deemed superfluous) the size was dropped to its current 5 MB.
Are there any built-in tools or available plugins that can help me analyze the workbook for other space hogs like that? I really want to get this sheet trimmed down in size, since I'll be copying it for re-use a lot.
For the record, a friend has helped me figure out what the problem was with this particular case.
Even though I didn't have content in most of the sheet any more, Excel was still retaining the million or so extra rows because they used to have content (the formula I'd nuked). Presumably this is because Excel still thinks I need them for whatever reason.
The solution is to highlight all the rows I don't need, right-click and select delete. The sheet is now only a few hundred K (most of it probably because a company logo is included).
Still, I'd be very much interested in knowing if there's any tools or plugins that could help catch these things in the future.