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