"calculate" at bottom of worksheet

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

Hi
have you chekced that automatic calculation is enabled?. Also try
hitting CTRL+ALT+F9

--
Regards
Frank Kabel
Frankfurt, Germany


bruno wrote:
"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

Thank you for your reply. I have automatic calculation
turned-on, and Cont+Alt+F9 does not remove
the "calculate" message. Any other suggestions? Thanks.

-----Original Message-----
Hi
have you chekced that automatic calculation is enabled?.
Also try
hitting CTRL+ALT+F9

--
Regards
Frank Kabel
Frankfurt, Germany


bruno wrote:
"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I
press F-
9. What should I do to track this down? Thank you.

.

Hi
did you get a circular reference error?

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Thank you for your reply. I have automatic calculation
turned-on, and Cont+Alt+F9 does not remove
the "calculate" message. Any other suggestions? Thanks.

-----Original Message-----
Hi
have you chekced that automatic calculation is enabled?. Also try
hitting CTRL+ALT+F9

--
Regards
Frank Kabel
Frankfurt, Germany


bruno wrote:
"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

.

Do you have lots of formulas?

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References

bruno wrote:

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

--

Dave Peterson

no, no cir ref error. I tried using the circular ref
error none-the-less, but found none.
-----Original Message-----
Hi
did you get a circular reference error?

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
Thank you for your reply. I have automatic calculation
turned-on, and Cont+Alt+F9 does not remove
the "calculate" message. Any other suggestions?
Thanks.

-----Original Message-----
Hi
have you chekced that automatic calculation is
enabled?. Also try
hitting CTRL+ALT+F9

--
Regards
Frank Kabel
Frankfurt, Germany


bruno wrote:
"calculate" appears at the bottom of my worksheet.
It
seems to be some type of circular reference and some
of
my formulas are not being calculated, even when I
press F-
9. What should I do to track this down? Thank you.

.
.

yes, a good twenty worksheets in my file, with about 500
lines in the main one.
-----Original Message-----
Do you have lots of formulas?

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536
Formula References

bruno wrote:

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I
press F-
9. What should I do to track this down? Thank you.

--

Dave Peterson

.

Hi
so it ould be that Excel isn't able to calculate automatically. But you
said automatic calculation was enabled. Also if you hit CTRL+ALT+F9
does the 'calculate' disappear at least so long as you enter no new
data?

--
Regards
Frank Kabel
Frankfurt, Germany


wrote:
yes, a good twenty worksheets in my file, with about 500
lines in the main one.
-----Original Message-----
Do you have lots of formulas?

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula
References

bruno wrote:

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

--

Dave Peterson

.

If it the same problem as described in that KB article, then excel will
calculate correctly (if you don't interrupt it). From that KB:


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.

Frank Kabel wrote:

Hi
so it ould be that Excel isn't able to calculate automatically. But you
said automatic calculation was enabled. Also if you hit CTRL+ALT+F9
does the 'calculate' disappear at least so long as you enter no new
data?

--
Regards
Frank Kabel
Frankfurt, Germany

wrote:
yes, a good twenty worksheets in my file, with about 500
lines in the main one.
-----Original Message-----
Do you have lots of formulas?

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula
References

bruno wrote:

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

--

Dave Peterson

.

--

Dave Peterson

What is the KB article? Where can I get a full copy? Thank you.

"Dave Peterson" wrote:

If it the same problem as described in that KB article, then excel will
calculate correctly (if you don't interrupt it). From that KB:


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.

Frank Kabel wrote:

Hi
so it ould be that Excel isn't able to calculate automatically. But you
said automatic calculation was enabled. Also if you hit CTRL+ALT+F9
does the 'calculate' disappear at least so long as you enter no new
data?

--
Regards
Frank Kabel
Frankfurt, Germany

wrote:
yes, a good twenty worksheets in my file, with about 500
lines in the main one.
-----Original Message-----
Do you have lots of formulas?

http://support.microsoft.com/?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula
References

bruno wrote:

"calculate" appears at the bottom of my worksheet. It
seems to be some type of circular reference and some of
my formulas are not being calculated, even when I press F-
9. What should I do to track this down? Thank you.

--

Dave Peterson

.

--

Dave Peterson