find/verify circular references

G

GoBobbyGo

I suspect that my worksheet has a circular reference because every time I
recalculate it, the value of certain cells changes.

Complicating this is the fact that excel seems not to be warning me about
circular references at all now. I can put =A2 in cell A1 and =A1 in cell A2,
and the customary warning about circular references doesn't pop up at all.

Any suggestions?
 
N

Niek Otten

You can make the warning revive:
Tools>Options>Calculation tab, uncheck Iteration

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I suspect that my worksheet has a circular reference because every time I
| recalculate it, the value of certain cells changes.
|
| Complicating this is the fact that excel seems not to be warning me about
| circular references at all now. I can put =A2 in cell A1 and =A1 in cell A2,
| and the customary warning about circular references doesn't pop up at all.
|
| Any suggestions?
 
C

Chip Pearson

If the Iteration option on the Calculations tab of the Options dialog is
checked, you will not receive any warnings about circular references.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
G

GoBobbyGo

Thank you both. That allowed me to track down and eliminate the circular
references.
 

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