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?

You can make the warning revive:
ToolsOptionsCalculation tab, uncheck Iteration

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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?

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?

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

"Niek Otten" wrote:

You can make the warning revive:
ToolsOptionsCalculation tab, uncheck Iteration

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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?