Excel2000-File size is increasing without changes!!

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

This morning, my excel file was 1.5M.
Right now, it is at 32M.
Seems to increase every time I save.
What have I done?

Joe
 
Joe

Excel over-estimates the size of the "used range" quite often.

On one of your sheets hit CRTL + END to see where you end up. Could be far
below and to the right of where your actual data range is.

For corrections and resetting see Debra Dalgleish's site for manual and coded
resetting instructions.

http://www.contextures.on.ca/xlfaqApp.html#Unused
 
Back
Top