Spreadsheet says CALCULATE when there is nothing to calculate

  • Thread starter Thread starter axw
  • Start date Start date
A

axw

Why would this error message appear as if the spreadsheet
needs to be calculated when it does not?
 
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
 
-----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?>
Click to expand...
 
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
 
Back
Top