Works spreadsheet-find circular ref.
 

I have a spreadsheet with a lot of data and up pops the "circular reference
in a cell" message. Is there a quick way to find it? I've spent a good
amount of time looking and haven't clue. Is there a formula to find it?
Thanks.

Works spreadsheet-find circular ref.
 

Have you looked up "circular reference" in Excel help?
The first topic on my list is "Allow or correct a circular reference".
--
David Biddulph

"dino" wrote in message
...
I have a spreadsheet with a lot of data and up pops the "circular reference
in a cell" message. Is there a quick way to find it? I've spent a good
amount of time looking and haven't clue. Is there a formula to find it?
Thanks.