Controlling Workbook File Size?

[Guest]

I have a workbook that has recently increased from 5meg to 30 meg. There are
no pivot tables -- only a couple small macros that involve a few lines of
vba. What could have caused the jumped.. and what can I do to fix it?

 

[Dave Peterson]

Just guesses...

The last used cell on each worksheet is way past where you think it should be.
See Debra Dalgleish's site to reset this last used cell.

http://www.contextures.com/xlfaqApp.html#Unused

Any chance you have objects (pictures/buttons/textboxes) in your workbook?

Sometimes pictures get duplicated by error.