Excel size grew very large all of a sudden [closed]

Question

My Excel file(contains macros) that was just 4 MB in size all of a sudden grew into a 12MB file... i made only some minor changes in the vba code and i dont think that is the reason for this.... What else could be the reason for this? Any Suggestions on how to repair this?

Answer 1

Most likely in the data sheets you have many rows with just formatting. Go into each sheet and delete all rows under the data and then resave the spreadsheet. An easy way to tell is the vertical navigation bar will extend a long way below were your data ends.

Answer 2

It might be a formatting issue. If Philip A Barnes suggestions are not enough (or if you want an automated solution), check the Microsoft Excel Excess Formatting Cleaner Add-in