Reducing Excel File Size

[mahadevan.swamy]

I have an excel file which consists of huge amount of formulas: right
and left, top and bottom. This file is linked to another file (input)
and based on this input, the data gets sorted in this huge file and
there are like million cells which consists of all the formulas. This
file size is currently 20 MB and it runs very slow every time i try to
open it or close it Is there a way to reduce this file size?

Thanks for your help

Swamy

 

[JLatham]

These procedures or the code provided in the discussion may help
http://www.contextures.com/xlfaqApp.html#Unused

But a "million" cells with formulas, it's likely you're still going to have
pretty darned big file once you're done anyhow.