XL Problem with "Not enough memory" and "Calculate" remains on

[MG]

I am trying to load an XL program that I last used a few wks ago
(Windows/XP, XL for Small Business 2000)

During the loading process, an error message "Not Enough Memory"
appears. After
this is acknowledged, the loading completes, but some lines do not
chart
on one of the pages (The XL file is 1.1MB, 10pages, with lots of
Calcs)

After loading, the word "Calculate" remains on the the bottom status
bar,
next to the "Ready" message

Apart from the missing lines on the chart, the program seems to
operate OK,
but when I save it, the whole of the XL platform crashes

Apart from different data in the file, the program is the same or
similar to many others that I have working

Has any kind person got any ideas on how to fix this problem ?

 

[Dave Hawley]

Hi MG

some tip here and a link to MS about the constant calculate message,
nothing to be too alarmed about.

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[MG]

Hi MG

some tip here and a link to MS about the constant calculate message,
nothing to be too alarmed about.

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Thanks to you Dave, I can now turn off the Calculate message by using
CTL ALT Del. That allows me to save the file without crashing the
system

BUT, then I cant reload the file - it seems to load the pages, but then
freezes with the message "Calculating 0%" on & stays like that..

Are there any further ideas out there ?

 

[Dave Hawley]

Hi MG

Sounds like you have spreadsheet design problem. Does the Workbook have
array formulae referencing large ranges? These (Array formula,
SUMPRODUCT etc) are the main offender when it come to calculation
sloooooooowwwww down. They are really only suitable for use in small
numbers and/or referencing smal ranges. In fact, I will rarely use them
unless the range is a single cell.

Lot's of lookup formulae on unsorted/large ranges are also a another
slow down. Dynamic Ranges: http://www.ozgrid.com/Excel/DynamicRanges.htm
are great for restricting formula references.

If the above does apply, you should replace them with the database
functions. These are far more efficient, although they take longer to
set-up initially. However, the short term pain is far outweighed by the
lonh term gain.

If not, you can run the risk of running it it manual calculation, but
this again is bad advice.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****