Calculation Problem

Posted by Douglas on November 01, 2001 8:08 AM

Hope someone out there has a solution!

I have a workbook which won't calculate properly. It does contain macros but I can't see why these would affect this. Basically, every time I open the workbook, it recalculates (which takes ages because it's a large file). After it reaches 100%, instead of the message in the status bar reading "Ready" it still reads "Calculate", indicating that it hasn't calculated properly.

Anyone had this happen before and found a solution??

hopefully,
Douglas

Posted by Tim on November 01, 2001 8:23 AM

I had this a long time ago - basically it was failing to report a circular reference - I collected all the latest MS patches and it went away.

Posted by Chris on November 01, 2001 8:41 AM

If Excel does not have a circular reference you will probably need to force Excel to recalculate by pressing

ctrl + alt + F9

Posted by Mark W. on November 01, 2001 11:39 AM

Microsoft Product Support Knowledge Base appears
to be down right now, but you may want to
investigate this link later...

http://support.microsoft.com/support/kb/articles/Q239/7/64.ASP?LN=EN-US&SD=gn&FR=0&qry=calculate%20status&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=XLW97