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