excel 07, i don't want circular reference arrows every time I open

Z

Zack H

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,
 
M

Mike H

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

Mike
 

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