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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
