Jul 27, 15 · One or more formulas contain a circular reference & may not calculate correctly Circular referencing are any references within a formula that depend upon the results ofOct 14, 15 · Thanks a lot Mr Chandoo and looking for useful excel tips from your end Here is my query Let me know how can we remove circular reference in an excel sheet if the same containing formulas I am aware that if want to remove the same need to click the excel options and click the formulas tab and enable err active calculationsIf you can't find the error, click the Formulas tab, click the arrow next to Error Checking, point to Circular Review the formula in the cell If you can't determine whether the cell is the cause of the circular reference, click Continue to review and correct the circular references in the
Excel Formulas Circular References
Excel formulas not calculating circular reference