Question about Microsoft Excel for PC
If you get this error then you need to find and correct the offending cells.
First click OK on the initial warning message. The Circular Reference toolbar and a help window should open (if not then go Tools -> Customise -> Toolbars tab, and check Circular Reference, then click close).
On the Circular Reference toolbar click on the down arrow of the text box which will show a list of offending circular cells. Select one and you will be taken to that cell, once there correct the formula. If you have further circular cells then select the next one from the list.
Posted on Jul 17, 2008
In order to remove this error message you need to locate and remove the incorrect references:
On the Formulas tab, in the Formula Auditing group, click the arrow on the Error Checking in-group button, point to Circular References, and then click the first cell listed in the submenu.
Tip You can move between cells in a circular reference by double-clicking the tracer arrows.
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 Circular References submenu.
Note The status bar displays the word "Circular References" followed by a reference to one of the cells contained in the circular reference.
Continue to review and correct the circular reference until the status bar no longer displays the word "Circular References."
Posted on Jun 06, 2008
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jul 26, 2015 | Microsoft PROJECT Computers & Internet
Mar 25, 2014 | Microsoft Office Professional 2007 Full...
Mar 18, 2013 | Microsoft Office Excel 2007 Full Version...
Jun 20, 2011 | Microsoft Office Professional 2007 Full...
Nov 07, 2010 | Microsoft Office Standard 2007: Windows
Aug 31, 2009 | Microsoft Office Word 2003 for PC
Apr 10, 2009 | Microsoft Office Professional 2007 Full...
Mar 28, 2009 | Microsoft Office 2003 Pro (269-07387) for...
Nov 05, 2008 | Microsoft Excel for PC
Oct 29, 2008 | Microsoft Office Professional 2007 Full...
Jan 28, 2016 | Microsoft Excel for PC
1,352 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: