anything in Excel...

It's Excel-o-lozy...

Circular Reference Error in Excel - search and remove

www.Excelolozy.com - After opening or calculating an Excel workbook / file "Circular Reference Error" pops-up. It may exist in one or multiple sheets.

This error is same as solving the following problem:
"Mr. A's age is 2 times of Mr.B's age and Mr. B's age is half of Mr. A's age. What is their age?"

To resolve it first we need to know the location where it exists.

To Know the Location Do as follows:
  • Go to Formula toolbar (Excel 2007)
  • Click arrow of "Error Checking" under "Formula Auditing"
  • Click on "Circular References"
Now resolve the given address one by one.

Anything in Excel, be an Excelolozian...

for best MS Excel Tips visit http://www.Excelolozy.com

gotta query??? drop a mail at mail@excelolozy.com