Jack-P-Winner
Member
I am getting a circular ref on one of my sheets if I change data too quickly. What are things to look for?
Circular Ref
- Thread starter Jack-P-Winner
- Start date
bobhc
Excel Ninja
I think one of the reasons the many who have looked at your post, but not answered may have some thing to do with the fact that your description does not giver any clue other than you are getting a CR, Formula,Function, Cell reference... Most definitely, but where, why, how.... do you not think just a bit more information would help!!! .
Jack-P-Winner
Member
hmm, Bob, I was just looking for general reasons why you would get a circ ref. I can post the spread sheet it was doing it on. Thanks
Somendra Misra
Excel Ninja
@Jack-P-Winner
Going with @bobhc comment , all we can give you this information about Circular ref. error kindly, visit below site for knowing about circular ref. and how to locate them. May be this can be useful to you.
http://chandoo.org/wp/2010/09/16/excel-circular-references/
Regards,
Going with @bobhc comment , all we can give you this information about Circular ref. error kindly, visit below site for knowing about circular ref. and how to locate them. May be this can be useful to you.
http://chandoo.org/wp/2010/09/16/excel-circular-references/
Regards,
Jack-P-Winner
Member
Thank you, the article help tremendously. I was copying a formula from 1 sheet to another and it was picking up the same row and column
Jack-P-Winner
Member
Bob,
why does it matter if you copy from one row or column to the next and I thought it would automatically rename the cells like if you have =A6 and move it to C it automatically changes to =C6
why does it matter if you copy from one row or column to the next and I thought it would automatically rename the cells like if you have =A6 and move it to C it automatically changes to =C6