View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default find/verify circular references

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)


"GoBobbyGo" wrote in message
...
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?