Deleting circular reference?

MV

New Member
Joined
May 6, 2005
Messages
3
I have the Circular toolbar on my screen, but I can't find a way to remove the circular reference.

Help??
 

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

shajueasow

Well-known Member
Joined
Oct 7, 2004
Messages
1,926
This from the HELP file in Excel (on Circular reference )

Locate and remove a circular reference

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

When the Circular Reference toolbar appears, tracer arrows appear that point out the cells that depend on the formula.

You can move between cells in a circular reference by double-clicking the tracer arrows.
 

Forum statistics

Threads
1,136,263
Messages
5,674,710
Members
419,521
Latest member
Jasonnie

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top