Calculate won't go away despite being on Automatic
 

My spreadsheet contains no external links, Calculation is set to Automatic.
I have used F9 on all of the sheets. Any thoughts?

Calculate won't go away? You mean in the status bar? That's a circular
reference. See "Circular References"
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to
Automatic.
I have used F9 on all of the sheets. Any thoughts?

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.


"Anne Troy" wrote:

Calculate won't go away? You mean in the status bar? That's a circular
reference. See "Circular References"
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to
Automatic.
I have used F9 on all of the sheets. Any thoughts?

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

"ted1973" wrote in message
...
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.


"Anne Troy" wrote:

Calculate won't go away? You mean in the status bar? That's a circular
reference. See "Circular References"
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to
Automatic.
I have used F9 on all of the sheets. Any thoughts?

Went to every sheet, no circular references. It's working though. -Theresa

"Anne Troy" wrote:

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

"ted1973" wrote in message
...
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.


"Anne Troy" wrote:

Calculate won't go away? You mean in the status bar? That's a circular
reference. See "Circular References"
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to
Automatic.
I have used F9 on all of the sheets. Any thoughts?

maybe...

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



ted1973 wrote:

My spreadsheet contains no external links, Calculation is set to Automatic.
I have used F9 on all of the sheets. Any thoughts?

--

Dave Peterson

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


"ted1973" wrote in message
...
My spreadsheet contains no external links, Calculation is set to Automatic.
I have used F9 on all of the sheets. Any thoughts?