Office button - Excel options - formulas tab = check 'Enable iterative
calculation'

Mike

"Zack H" wrote:

I know i have a circular reference and I am ok with it. In the old version of
excel, you could ignore the circular reference, in this version, the program
automatically posts arrows, which you have to remove in the formula auditing
toolbar. Is there a way to turn this off? Maybe just notify me of the error
and if I click ok, show me the errors, if "ignore" no arrows?
thanks,