Circular reference, Maximum number of formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle - 06 Feb 2008 17:44 GMT

I have come across a spreadsheet in Excel 2000 which exceeds the 65536
number of formulas that Excel's dependency table can keep track of. The
consequence is that 'Calculate' is permanently diplayed in the status bar,
AND (much more important), it cannot keep track of circular references.

By opening the file on my machine with Excel 2003 SP3, I was able to locate
the circular references and correct them.

What is the max number of formulas that Excel 2003 can track in its
dependency database?

What about 2007 does that increase the number of formulas that can be
tracked?

Thanks

M

Reply to this Message

Niek Otten - 06 Feb 2008 17:56 GMT

For Excel 2003 it's the same as for 2000.
From Excel 2007 Help:

Cross-worksheet dependency 64,000 worksheets that can refer to other sheets
Cross-worksheet array formula dependency Limited by available memory
Area dependency Limited by available memory
Area dependency per worksheet Limited by available memory
Dependency on a single cell 4 billion formulas that can depend on a single cell

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have come across a spreadsheet in Excel 2000 which exceeds the 65536
| number of formulas that Excel's dependency table can keep track of. The
[quoted text clipped - 13 lines]
|
| M

Reply to this Message