Not enough system resources to display completely

[Heavy Excel user]

I get the notification "Not enough system resources to display completely"
whenever I try to open a fairly large (4MBytes) and complex (tons of
formulaes)Excel file. The file is opened but the display is garbled. I have
created this file over a period of time myself, so now suddenly why am I
unable to open it.

I tracked the memory usage around the time I get this error and it was at
around 58 MBytes. I am using Excel 2003, which is supposed to have a per
instance limit of 1GBytes.

I have a lot of critical data in there which I do not want to loose. What
should I do?

 

[aidan.heritage]

Do all the formulas need to stay as formulas? If the formula was used
once to work out a value which is now locked into place, then copy and
paste special values - this would reduce the complexity.

 

[NMThoman]

Wondering if you ever got a better solution to this problem, as we are now
experiencing the same thing. Rebooted the machine and opened ONLY this
spreadsheet, still having the problem. Suggestions?

Thanks,
Nichole