Disable or Enable Circular Reference Warning on MS Excel

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 LogoDisable or Enable Circular Reference Warning on Microsoft Excel, and then click Excel Options.
Disable or Enable Circular Reference Warning on Microsoft Excel

At MS Excel 2010, click FileDisable or Enable Circular Reference Warning on Microsoft Excel, and then click Options.
Disable or Enable Circular Reference Warning on Microsoft Excel

2. From the Excel Options, click FormulasDisable or Enable Circular Reference Warning on Microsoft Excel, 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)
Disable or Enable Circular Reference Warning on Microsoft Excel

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! :D

(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

Related Posts Plugin for WordPress, Blogger...
Share

Comments are closed.