How to stop a recurrent circular reference error message ?

G

Guest

I converted a spreadsheet to Excel from Quattro Pro. Whenever I open it
there is an error message about a circular reference. There is none and
never has been. Nevertheless the annoying message appears every time. I
finally deleted the formula and cleared all cells containing its result.
Still get the circular reference error. How can I turn this off once & for
all ?
 
G

Guest

What version of Excel are you using? In 2007, if you click the office button
in the upper lefthand corner, choose Excel options, Formulas tab, check
Enable Iterative Calculation. This should allow the circular reference.
 

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

Similar Threads

How to stop the circular reference message from reappearing 1
How to slove: Circular Reference Warning 1
How to Eliminate Circular Rerference Popup Screen? 1
How do you initialize the values in a circular reference? 2
excel 07, i don't want circular reference arrows every time I open 1
Inserting current date when number entered in cell & Circular reference error? 4
Getting rid of a circular reference error message 9
How do I correct a complex circular reference? 2

Top