Question about Microsoft Excel for PC
Circular Reference Warning
One or more formulas contain a circular reference and may not calculate correctly. Circular reference are any refereces within a formula that depend upon the results of that same formula. For example, a cell that refers to its own value or a cell that referes to another cell which depends on the original cell's value both contain circular references.
For more information about understznding, finding and removing circular references, click ok. if you want to create a circular reference, click cancel to continue.
I have a value in cell E1 say 2500000. I now enter the formula =E1/1000000 the result is a circular reference. How to remove it ?
Posted on Apr 06, 2010
Clicking cancel will invalidate the formulae, circular references refer to the dependant and precedent cells using each other.
Track/ Audit depending on your Excel version to show which formulae is incorrect - or options view, tick show formaulae and remove them.
Posted on May 22, 2009
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
Oct 31, 2008 | Computers & Internet
Apr 09, 2014 | Microsoft Excel for PC
Mar 18, 2013 | Microsoft Office Excel 2007 Full Version...
Jul 19, 2012 | Microsoft Excel for PC
Jun 20, 2011 | Microsoft Office Professional 2007 Full...
Jul 08, 2009 | Microsoft Excel for PC
Mar 16, 2009 | Autodesk AUTOCAD LT 2008 SLM 10 SEATS...
Nov 05, 2008 | Microsoft Excel for PC
Jun 06, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
1,301 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: