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
|