Is it possible to get rid of circular reference in Excel sheet

[Iyyappan]

I don't know how it happened but there's a circular reference in the file I had created and it ruins my entire file. I do not have any kind of backup for my file and I do not want to create another one. There is a very large amount of data and it will take weeks for me to create a new file. Any help is appreciated.

[Shurod]

Circular reference means you have included in a formula the cell where the formula is, in excel 2007 go to Formulas, Formula Auditing, Error Checking,Circular References, and then click the first cell listed in the submenu.

[AnitG]

Circular reference occurs, when ur refering the same cell in the formulae. (just like cutting a tree by sitting on one of its branch). Find the circular reference cell and rectify the formulae, just removing the formulae may not right thing always. There are two ways to find the circular reference in the spreadsheet. First is by looking at the end of Excel. The bar below sheetname will give you information on Circle Refrence cell. Second in go to formulae bar and then click on error checking. And for circular references in excel 2003 > view > Tool bars > circular reference.