| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with Circular (?)
Hi
I am trying to refresh my calculations and I am getting the infro Circular : 095, or Circular : B20 Excel doesn't recalculate my changes. Any ideas why? thanks Eva |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with Circular (?)
You have a cell reference that pointing to itself, that is a big no no. Find
it using the Circular reference tool, If the Circular Reference toolbar is not displayed, click Customize on the Tools menu, click the Toolbars tab, and then select the Circular Reference check box. On the Circular Reference toolbar, click the first cell in the Navigate Circular Reference box. Review the formula in the cell. If you cannot determine whether the cell is the cause of the circular reference, click the next cell in the Navigate Circular Reference box. Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference. Continue to review and correct the circular reference until the status bar no longer displays the word "Circular." -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Eva" wrote: Hi I am trying to refresh my calculations and I am getting the infro Circular : 095, or Circular : B20 Excel doesn't recalculate my changes. Any ideas why? thanks Eva |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with Circular (?)
Thanks Michael. It is very helpful. One more question.
Were exactly is a Circular Reference check box? I have Circular Reference toolbar open and I don't know what to do now. Thanks Eva "Michael" wrote: You have a cell reference that pointing to itself, that is a big no no. Find it using the Circular reference tool, If the Circular Reference toolbar is not displayed, click Customize on the Tools menu, click the Toolbars tab, and then select the Circular Reference check box. On the Circular Reference toolbar, click the first cell in the Navigate Circular Reference box. Review the formula in the cell. If you cannot determine whether the cell is the cause of the circular reference, click the next cell in the Navigate Circular Reference box. Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference. Continue to review and correct the circular reference until the status bar no longer displays the word "Circular." -- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Eva" wrote: Hi I am trying to refresh my calculations and I am getting the infro Circular : 095, or Circular : B20 Excel doesn't recalculate my changes. Any ideas why? thanks Eva |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need help with Circular (?)
Hi
Forget my question,. I know now and I find out what hapened. Thanks!! Eva "Eva" wrote: Hi I am trying to refresh my calculations and I am getting the infro Circular : 095, or Circular : B20 Excel doesn't recalculate my changes. Any ideas why? thanks Eva |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Circular Ref. | Excel Discussion (Misc queries) | |||
| Circular:G4? | Excel Worksheet Functions | |||
| 'circular reference' | Excel Discussion (Misc queries) | |||
| circular reference when using a UDF | Excel Discussion (Misc queries) | |||
| circular reference when using a UDF | Excel Worksheet Functions | |||
Linear Mode
