M myfreeacct May 7, 2010 #1 I don't know how it happened but there's a circular reference in the file i created and it ruins my entire file..:'(
I don't know how it happened but there's a circular reference in the file i created and it ruins my entire file..:'(
E Eduardo May 7, 2010 #2 Hi, 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.
Hi, 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.
D Dave Peterson May 7, 2010 #3 You may want to try Stephen Bullen's utility: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip
You may want to try Stephen Bullen's utility: http://www.oaltd.co.uk/Excel/Default.htm Look for FindCirc.zip