(If the word 'Circular' is shown in the status bar without referencing which cell, switch to another worksheet.) How To Turn Off Circular Reference In Excel Macĥ. If you find no such mistake that could be the cause of the circular reference message, click to the next cell in the 'Navigate Circular Reference' box. Examine the formula in the highlighted cell carefully for errors i.e., referencing the cell itself. Click on and highlight the first cell in the 'Navigate Circular Reference' box within the 'Circular Reference' toolbar.Ĥ. Click the 'OK' button and close the window.ģ.
Click on the 'Toolbars' tab at the top of the window that appears, then check the 'Circular Reference' check box if it is not already checked. Open the 'Tools' drop-down menu at the top of the screen if the 'Circular Reference' toolbar is not displayed, then click 'Customize.'Ģ. ** Modeling Tip – If/Else is a powerful forumla.
