| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| 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
