View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default how will i delete the circular reference in my file?

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.



"myfreeacct" wrote:

I don't know how it happened but there's a circular reference in the file i
created and it ruins my entire file..:'(