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
 
Top