The code below identify the first circular reference on each worksheet and backcolor it in red. If you open a workbook that has the circular reference, it will show you the prompt as soon as the workbook opens.In case you get a circular reference warning prompt once and you dismiss it, it will not show the prompt again the next time.In case the circular reference is not in the active sheet (but in other sheets in the same workbook), it will only show Circular reference and not the cell address.In case the iterative calculation is enabled (covered later in this tutorial), the status bar will not show the circular reference cell address.There are a few things you need to know when working with circular references: On the left part of it, it will show you the text Circular Reference along with the cell address. If there is none, you will not see any cell reference,Īnother quick and easy way to find the circular reference is by looking at the Status bar. This is a companion video to show how to turn on iteration on a Mac so that the time stamp function for attendance will work. Once you have addressed the issue, you can again follow the same steps above and it will show more cell references that have the circular reference. Step 3: Move mouse over the Circular References item in the drop down list, and it shows the cells with circular references.
0 Comments
Leave a Reply. |