What is the upper limit to the dependencies for Excel?
 

If I have a particularly complicated spreadsheet with many formulae (talking
thousands and thousands of rows here)? Excel has an upper limit to the
dependencies it can keep track of (required to permit operation of its smart
recalculation engine).
Does anyone know the upper limit to the dependencies for Excel 2003 and 2007?
Thanks in advance for any suggestions
Eric

What is the upper limit to the dependencies for Excel?
 

Excel 2007:
http://office.microsoft.com/en-us/ex...33#Calculation
Excel 2003:
http://office.microsoft.com/en-us/ex...CH062527721033

"Eric" wrote:

If I have a particularly complicated spreadsheet with many formulae (talking
thousands and thousands of rows here)? Excel has an upper limit to the
dependencies it can keep track of (required to permit operation of its smart
recalculation engine).
Does anyone know the upper limit to the dependencies for Excel 2003 and 2007?
Thanks in advance for any suggestions
Eric

What is the upper limit to the dependencies for Excel?
 

see http://www.decisionmodels.com/calcsecretsf.htm

Charles
_________________________________________
FastExcel 2.3
Name Manager 4.0
http://www.DecisionModels.com

"Eric" wrote in message
...
If I have a particularly complicated spreadsheet with many formulae
(talking
thousands and thousands of rows here)? Excel has an upper limit to the
dependencies it can keep track of (required to permit operation of its
smart
recalculation engine).
Does anyone know the upper limit to the dependencies for Excel 2003 and
2007?
Thanks in advance for any suggestions
Eric