Spreadsheet says CALCULATE when there is nothing to calculate

[axw]

Why would this error message appear as if the spreadsheet
needs to be calculated when it does not?

 

[Bernie Deitrick]

axw,

When you have a lot of formulas (more than, IIRC, 65536 total formula
dependencies), Excel will always show that message.

HTH,
Bernie
MS Excel MVP

 

[Guest]

-----Original Message-----
axw,

When you have a lot of formulas (more than, IIRC, 65536 total formula
dependencies), Excel will always show that message.

HTH,
Bernie
MS Excel MVP



Thx - and is there a way to tell if there are mre than IIRC, 65536 total formula
dependencies?>

 

[Bernie Deitrick]

Take a look here (list courtesy of Tom Ogilvy):

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q239764
XL97: Calculate Message Remains in Status Bar If 65,536 Formula References
(Q239764)
When you enter formulas that include cell references, the "Calculate"
message may remain in the status bar.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
(Q243495)
When you enter formulas that include cell references, the "Calculate"
message may remain in the status bar.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q248179
XL2000: Calculation Problems When Custom Function Creates a Defined Name
(Q248179)
When you press ENTER after typing a function into a worksheet, the
worksheet may not be calculated correctly, and the message "Calculate" may
remain in the status bar, instead of disappearing when you press F9.

HTH,
Bernie
MS Excel MVP