[SOLVED] 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?

[[email protected]]

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



"Heavy Excel user" wrote:

> 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?
>