Circular References

[ElmerS]

Hi,

In have only one WB open in Excel 2003 and upon saving it displays a warning regarding a
Circular References but it does not show the well known window from where I can identify the cell that causes the circular error.

Down, at the Status Bar it states 'Circular' but does not present the cells address.

I In Excel 2010, in cell G8, I deliberately caused a Circular References where after the status bar states Circular References: G8

What should I do in Excel 2003 in order to locate the cell with the Circular References ?

I would like to emphasize that the Circular Reference Toolbar does not pop-up and although I found it through Tools>Customize - It does not show the cells address causing the Circular Reference

Thanks, Elm

[teylyn]

ElmerS,

check formulas in data validation, conditional formatting and range name definitions. There could be circular references there, depending on how these are set up.

[ElmerS]

Thanks,

The WB is too big to search by eye.

A friend sent me a small macro which searches and locates them.

Elm