Circular References in Excel 2007

**ExcelTip** · 11-15-2007, 03:00 AM

A Circular Reference is created when a formula refers back to its own cell, either directly or indirectly.

Select Formulas tab -> Formula Auditing group -> Error Checking -> Circular Reference

Or

Find the address of Circular References in the Status Bar.

The reference of a Circular References appears only in the sheet where the Circular References is located. At the Status Bar of any other sheet in the workbook the words Circular References appear without the reference.

**sallafin** · 11-24-2013, 09:06 AM

Thanks a ton for your help...

**kisanvikas2015** · 06-05-2015, 07:43 AM

Hi,

I tried all of the above steps & I found Circular reference is disable as compare to other options Error Checking & Trace error which are enable.
Can someone please help me if I am doing some thing incorrect.

Thanks in advance for any help!

Regards,
Vikas