Circular Reference ?

K

Kevin

When a circular reference is made, Excel automatically
launches a help screen. Is there a setting that will turn
this function off?

Please respond if answer is known. Thanks!
 
G

Gord Dibben

Kevin

Tools>Options>Calculate checkmark in "Iterations" and set to 1.

Not customary practice to use circular references. What are you doing that
causes the CR? Do you really need this operation?

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 

Ask a Question

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.

Ask a Question

Top