ExcelBanter - How do I locate a circular reference error?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I locate a circular reference error? (https://www.excelbanter.com/excel-worksheet-functions/174757-how-do-i-locate-circular-reference-error.html)

adamsj3

How do I locate a circular reference error?

Gord Dibben

How do I locate a circular reference error?

On the status bar you should have a message Circular:cell ref

Or you could go to ViewToolbars and bring down the Circ Ref Toolbar and click
the dropdown arrow.

Gord Dibben MS Excel MVP

On Mon, 28 Jan 2008 16:47:02 -0800, adamsj3
wrote:

All times are GMT +1. The time now is 02:24 PM.