I have an excel file that is 50mb and I don't know why it is that huge. I did not create this file and was asked to look at it and figure out why it takes 10 minutes to open? There is 3 tabs and very little data. How can it be so huge??
-make sure you go through every sheet.....the author has most likely colored all of the sheets white so that the user would not see un-used cells....that takes massive amount of memory.....undo that by making them "no color" instead of white
another thing that you can do once you try that, would be to copy your sheets into a fresh Excel file. make sure to do it in the exact same order, and be sure to take your macros with you.
i had a file that went from 12 MB to 200 KB within a matter of minutes after i did the above two.
The code lookp thru each worksheet, finding the boundaries of used ranges, and then deletes everything outside that.
It might sound stupid to delete already empty rows/columns, as they just come back, but the thing of it is that Excel sometimes remembers that you once formated a whole row or column and considers that as an active par of your book, to be saved.