View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Héctor Miguel Héctor Miguel is offline
external usenet poster
 
Posts: 434
Default How to Eliminate Circular Rerference Popup Screen?

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.