"Not enough system resources to display completely" while opening

[Guest]

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?

 

[Guest]

I'd recommend restarting the computer and using safe mode as this runs with
the bare mininum of background services and as such should be able to
dedicate more memory to excel. With regards to the actual file, have you
considered linking data between workbooks. I do the sales statistics for the
company I work for, we have 100 departments and each has a figure over 7
days, what I do is have a seperate file for each week and then then the data
is linked into one master workbook in order to produce the monthly stats.
This limits the size of the master file and as such might eliminate the
problems you are experiencing.

Regards

Peter