how will i delete the circular reference in my file?

M

myfreeacct

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to slove: Circular Reference Warning 1
Help me find a circular reference cells located in unknown multita 2
Name of file opened, being viewed 2
offset formula causing Circular reference 0
Embedded Excel into Word with Tables 0
How do you initialize the values in a circular reference? 2
Active Content in this file is blocked issue 1
excel 07, i don't want circular reference arrows every time I open 1

Top