How to Eliminate Circular Rerference Popup Screen?

[Phredrique]

I get a "circular reference" every time I open a spreadsheet which states
that Microsoft cannot calculate a formula due to a circular reference.
Tracing the source indicates that there is no circular reference problem, but
rather it wants the cells containing the formulas locked. I don't want to
lock the cells and I don't to deal with the annoying popup window everytime I
opent he spreadsheet. Anyone have an anticdote for this?

 

[Héctor Miguel]

hi, !

I get a "circular reference" every time I open a spreadsheet
which states that Microsoft cannot calculate a formula due to a circular reference.
Tracing the source indicates that there is no circular reference problem
but rather it wants the cells containing the formulas locked.
I don't want to lock the cells and I don't to deal with the annoying popup window
everytime I opent he spreadsheet. Anyone have an anticdote for this?

is there any possibility that "circular reference" being caused from names collection ?
some circular references are difficult to find/see, so you could start revieweing this:
-> http://www.decisionmodels.com/calcsecretsk.htm

hth,
hector.