Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Circular References | Excel Worksheet Functions | |||
circular references | Excel Discussion (Misc queries) | |||
circular references | Excel Discussion (Misc queries) | |||
Circular references | Excel Worksheet Functions | |||
Help :Circular References | Excel Worksheet Functions |