Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I locate a circular formula?
I have a workbook with more than 30 worksheets. Each time I open the
workbook I get the alert, "Microsoft Office Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command (Edit menu)." At this point of course the "undo" command is useless and it has been too long for me to know what the last formula was that I entered. Also, I have also attempted (numerous times) to use the Excel Help and have taken note of the "Note" below. Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference. Is there any other way to pinpoint the circular formula in my workbook? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I locate a circular formula?
On the worksheet you can use TOOLSFORMULA AUDITINGTRACE DEPENDANTS Di;346132 Wrote: I have a workbook with more than 30 worksheets. Each time I open the workbook I get the alert, "Microsoft Office Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command (Edit menu)." At this point of course the "undo" command is useless and it has been too long for me to know what the last formula was that I entered. Also, I have also attempted (numerous times) to use the Excel Help and have taken note of the "Note" below. Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference. Is there any other way to pinpoint the circular formula in my workbook? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=96841 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I locate a circular formula?
You may want to try Stephen Bullen's utility:
http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip Di wrote: I have a workbook with more than 30 worksheets. Each time I open the workbook I get the alert, "Microsoft Office Excel cannot calculate a formula. There is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the Undo command (Edit menu)." At this point of course the "undo" command is useless and it has been too long for me to know what the last formula was that I entered. Also, I have also attempted (numerous times) to use the Excel Help and have taken note of the "Note" below. Note The status bar displays the word "Circular," followed by a reference to one of the cells contained in the circular reference. If the word "Circular" appears without a cell reference, the active worksheet does not contain the circular reference. Is there any other way to pinpoint the circular formula in my workbook? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I locate a circular reference error? | Excel Worksheet Functions | |||
Formula to locate a cell | Excel Discussion (Misc queries) | |||
How to locate the formula icon on toolbars? | Excel Discussion (Misc queries) | |||
FORMULA TO LOCATE NEXT DATE | Excel Worksheet Functions | |||
how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions |