T
ted1973
My spreadsheet contains no external links, Calculation is set to Automatic.
I have used F9 on all of the sheets. Any thoughts?
I have used F9 on all of the sheets. Any thoughts?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anne Troy
Calculate won't go away? You mean in the status bar? That's a circular
reference. See "Circular References"
http://www.officearticles.com/excel/most_common_mistakes_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
reference. See "Circular References"
http://www.officearticles.com/excel/most_common_mistakes_in_microsoft_excel.htm
************
Anne Troy
www.OfficeArticles.com
T
ted1973
Very strange. I opened the Circular Reference Toolbar and there were no
cells listed in the drop down, but the Calculate message at the bottom has
gone away for now. Thanks.
cells listed in the drop down, but the Calculate message at the bottom has
gone away for now. Thanks.
A
Anne Troy
Okay. It'll say Calculate on ALL worksheets. It'll show the cell with the
circular reference only on the worksheets that contain them.
************
Anne Troy
www.OfficeArticles.com
circular reference only on the worksheets that contain them.
************
Anne Troy
www.OfficeArticles.com
T
ted1973
Went to every sheet, no circular references. It's working though. -Theresa
D
Dave Peterson
maybe...
http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
http://support.microsoft.com/default.aspx?scid=243495
XL: Calculate Message Remains in Status Bar If 65,536 Formula References
B
Bernie Deitrick
ted,
If you have more than a set number of formulas (I think it's 65536) then Excel always shows
"Caclulate".
HTH,
Bernie
MS Excel MVP
If you have more than a set number of formulas (I think it's 65536) then Excel always shows
"Caclulate".
HTH,
Bernie
MS Excel MVP