Where is circular reference?

  • Thread starter Thread starter Brett
  • Start date Start date
B

Brett

I'm using Excel 2002. I have a spreadsheet with several function cells.
When I open the sheet, I get a circular reference message. It doesn't tell
me where the reference is. I can click OK and the help appears or Cancel
and the popup goes away.

How can I find out which cell is causing the circular reference?

Thanks,
Brett
 
Click on TOOLS MENU then click CUSTOMIZE then click the
TOOLBARS tab and select the CIRCULAR REFERENCE check box
and you will get a pop up for locating and resolving
circular references.
 
Back
Top