Finding Circular References
 

Hi.

I have a workbook that displays "Circular references" in the lower left
corner.
I have checked each worksheet but the message does not change to include the
cell reference containing the error on any of them.
I have checked that there are no hidden sheets (including Excel Very Hidden).

Does anyone have any ideas about how to proceed?

I can't install new software or add-ins as that is a sacking offence.

Regards

Phil

Finding Circular References
 

Hi,

Try - right-clicking any toolbar and turnning on Circular References, then
open the Navigate Circular References drop down and see what you get.

Also check your Range Names.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Philip J Smith" wrote:

Hi.

I have a workbook that displays "Circular references" in the lower left
corner.
I have checked each worksheet but the message does not change to include the
cell reference containing the error on any of them.
I have checked that there are no hidden sheets (including Excel Very Hidden).

Does anyone have any ideas about how to proceed?

I can't install new software or add-ins as that is a sacking offence.

Regards

Phil

Finding Circular References
 

Hi,

This could also happen if all the following conditions are satisfied:

1. More than 1 workbook is open; and
2. One of them has a circular reference; and
3. The workbook which does not have the circ is active.

To identify the circular reference cell, ensure that only that workbook is
open,

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Philip J Smith" wrote in message
...
Hi.

I have a workbook that displays "Circular references" in the lower left
corner.
I have checked each worksheet but the message does not change to include
the
cell reference containing the error on any of them.
I have checked that there are no hidden sheets (including Excel Very
Hidden).

Does anyone have any ideas about how to proceed?

I can't install new software or add-ins as that is a sacking offence.

Regards

Phil