Need help with Circular (?)

E

Eva

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
 
M

Michael

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."
 
E

Eva

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top