File Size

[Ldyflyr]

Hi:

I have a file that went from 100KB to 8MB. I only added a few rows to it.
Does anyone have any idea what would cause it or how to find out? I did not
add any pictures to the file.

Thanks,

 

[Gord Dibben]

Have a read at Debra Dalgleish's site.

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


Gord Dibben MS Excel MVP

 

[Jim Thomlinson]

You need to reset the used range (as a guess). Take a look at the scroll
bars. Chances are you can scroll well past the end of the populated data
(probably to 65,536)... check out this link to reset the used range...

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