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

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

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

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