View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

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.

Mark wrote:

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