| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
|
#6
|
|||
|
|||
|
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 |
|
#7
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with sumif to calculate column | Excel Discussion (Misc queries) | |||
| find automatic page breaks | Excel Worksheet Functions | |||
| How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
| Not able to calculate. | Excel Worksheet Functions | |||
| Automatic Calculate Worksheets | Excel Worksheet Functions | |||
Hybrid Mode
