Memory

[Michael]

I have a spreadsheet at work that contains so many
calculations, Excel will not calculate. A corp tech
person at work told me that Excel 2000 has a maximum
internal memory (called HEAP Memory) of 64MB. If your
spreadsheet is extensive enough, Excel will not calculate
regardless of the memory capacity of your PC. Does
anyone know if any of the later versions of Excel (XP or
2003) have addressed this issue and allow more than 64MB
memory to be allocated to Excel?

 

[Charles Williams]

Hi Michael,

I think your corp tech person has confused two different things:

- excel 2000 has a memory limit of 64-80MB for formulae. when you exceed
this you get a message saying "out of Memory"
see http://www.decisionmodels.com/memlimitsc.htm for more details. Excel
2002 has double the limit of excel Excel 2000 , and Excel 2003 has a
substantially increased memory capacity (in excess of 768MB) .

- excel has an internal limit of 64000 unique dependencies. when a workbook
reaches this limit Excel will always show "calculate" in the status bar, but
it will still calculate when you press F9. This behaviour has not altered in
Excel 2003.
see http://www.decisionmodels.com/calcsecretsf.htm


Charles
______________________
Decision Models
FastExcel Version 2
www.DecisionModels.com