Circular reference, Maximum number of formulas

[Michelle]

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

 

[Niek Otten]

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


--
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
| 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
|