Try this link

[url="http://support.microsoft.com/kb/243495/en-us"]

The Calculate message may remain in the status bar when you enter
formulas that include cell references
View products that this article applies to.
Article ID : 243495
Last Review : January 11, 2005
Revision : 4.1
This article was previously published under Q243495
SYMPTOMS
When you enter formulas that include cell references, the "Calculate"
message may remain in the status bar, even though calculation is set to
automatic, or if you have manually calculated the file by pressing the
F9 key.

Additionally, when you use the Trace Dependents tool, all dependents
may not appear.
CAUSE
This behavior occurs when there are 65,536 or more dependencies to
unique references (the level or number of links between formulas).

NOTE: If the Iteration option is turned on, circular references also
cause the "Calculate" message to remain in the status bar.
MORE INFORMATION
Microsoft Excel calculates during different events like column
auto-resizing, when entering anything in any cell, and so forth.
However, Excel can only track 65,536 dependencies to unique references
for automatic calculation.

After the workbook has passed this limit, Excel no longer attempts to
recalculate only changed cells. Instead, it recalculates all cells
after each change. This behavior is by design of Microsoft Excel.

Microsoft Excel will correctly calculate all formulas. However, the
"Calculate" message in the status bar indicates that Microsoft Excel
can no longer track the formula dependencies and is calculating every
formula in the workbook after each change. If you are unsure when the
last calculation event took place and you want to be sure your formulas
are up to date, simply start a calculation manually. To do this, press
CTRL+ALT+F9 and wait until "Calculating Cells: n%" disappears and
"Calculate" returns to the status bar.

--------------------------------------------------------------------------------

APPLIES TO
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition
• Microsoft Excel 2000 Standard Edition
• Microsoft Excel 97 Standard Edition

Back to the top

Keywords: kbprb KB243495


--
mikluk
------------------------------------------------------------------------
mikluk's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29236
View this thread: http://www.excelforum.com/showthread.php?threadid=515728