How to deal or turn off the Circular Reference warning prompt on Microsoft Office Excel 2003, 2007, 2010
What is Circular Reference? A circular reference can have a significant impact on performance because it can iterate indefinitely. Iteration is the repeated recalculation of a worksheet until a specific numeric condition is met.
On Microsoft Excel by default it was disabled or turned off, but if you want to handle it, you can remove the circular reference or enable the iterative calculations then input the maximum iterations.
HOW TO DO IT? SIMPLE.If you are using Microsoft Office Suite 2003, 2007 or 2010, then luckily, you have this option.
1. At MS Excel 2007, click the Microsoft Office Button Logo, and then click Excel Options.
At MS Excel 2010, click File, and then click Options.
2. From the Excel Options, click Formulas, and then from there, go to Calculation options section, then click Enable iterative calculation, and then set the Maximum Iterations to 1. (This should be enough to disable/turn off the Circular Reference Warning Prompt)
Other than that, you can set other number depends on the requirements. For MS Excel 2003, go to Tools > Options > Calculation > Iteration…
(Note: Turning off the warning is not appropriate, it should function and set to its purpose. But for willingness of other users to disable it, this tip/guide provides the accuracy to develop a solution. Any further loss or damage of a certain work is not held responsible by the author)
To know more about Circular Reference of MS Excel click here
Feel free to comment here if you found one interesting to share or your own experience. That’s all! I hope this guide and tips helps you out! Cheers!
(Note: Microsoft (Windows and MS Office Suite – Excel) Logo/Images/Pictures has a respective copyright. I used it for demonstration purpose only.)
BUY MICROSOFT OFFICE 2007,2010 AT AMAZON US:
Related Entries / Links / Sources / Articles / Sources:
MS Office Help Support – Excel – Remove or allow circular reference – Official Site