When I create a circular reference, Excel spends out 2 minutes trying to display help and the circular reference tool bar. I don't mind the toolbar, but how do I stop the help from being displayed.
This is one way to prevent the error and the help window from opening:
Tools -> Options -> Calculation, check iteration.
Now Excel only calculates the circular references only so many times, that
one of the specified conditions (maximum iterations OR maximum change) come
true.
