If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Circular reference, Maximum number of formulas
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 |
#2
|
|||
|
|||
Circular reference, Maximum number of formulas
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 "Michelle" wrote in message ... |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 | |
Thread Tools | |
Display Modes | |
|
|