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.