File Size
 

I recently created a file that started out pretty big b/c of some hefty data
ranges in the equations within the file. However when I made these ranges
significantly smaller the file acutally got bigger b/c Excel is essentially
recording all of the actions I make.

Is there any way to have Excel disregard that larger portion that originally
took place and in return just have a smaller file? I am aware of compressing
files but those just go right back to the same larger size they were once you
open them.

Thanks,
Curtis

File Size
 

See if this is of any help:
http://www.contextures.com/xlfaqApp.html#Unused


"Curtis" wrote:

I recently created a file that started out pretty big b/c of some hefty data
ranges in the equations within the file. However when I made these ranges
significantly smaller the file acutally got bigger b/c Excel is essentially
recording all of the actions I make.

Is there any way to have Excel disregard that larger portion that originally
took place and in return just have a smaller file? I am aware of compressing
files but those just go right back to the same larger size they were once you
open them.

Thanks,
Curtis