Share via

Circular Reference Error message

Anonymous
2021-09-05T23:18:50+00:00

I continue to get this message every time I open workbook #1. I have checked for circular references on my own and have not found any in the workbook/sheets.

Could this be because a different workbook (workbook #2) imports data from workbook #1? I do not get an error message when I open workbook #2 nor are there any circular references in it.

Any ideas or help with this?

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2021-09-05T23:55:48+00:00

    Hi,

    If you import the data, not link it, that should not cause any circular references. Circular references can be difficult to track down, for example they can be in range name. A innocent looking formula like =OFFSET(A1,,,,10) placed in A9 would generate a circular reference, as would many others. If you want someone to track the problem down, they will need to see the file.

    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-09-08T06:15:14+00:00

    Hi Eric,

    If you still need further support, please do not hesitate to reply to me.

    Best regards,

    Jazlyn

    0 comments
  2. Anonymous
    2021-09-15T16:12:59+00:00

    Hi Eric,

    If you still need further support, please do not hesitate to reply to me.

    Best regards,

    Jazlyn

    Jazlyn,

    Thank you for your reply. I hate to waste anyone's time with this but if you are willing to view the file I will be glad to send it. It is just a bunch of football statistics that really isn't that important.

    Eric

    0 comments
  3. Anonymous
    2021-09-15T16:13:34+00:00

    Hi,

    If you import the data, not link it, that should not cause any circular references. Circular references can be difficult to track down, for example they can be in range name. A innocent looking formula like =OFFSET(A1,,,,10) placed in A9 would generate a circular reference, as would many others. If you want someone to track the problem down, they will need to see the file.

    Shane,

    Thank you for your reply. I hate to waste anyone's time with this but if you are willing to view the file I will be glad to send it. It is just a bunch of football statistics that really aren't that important.

    Eric

    0 comments
  4. Anonymous
    2021-09-16T12:43:56+00:00

    Hi Eric,

    Thank you for the reply. If you still want to get help about this issue, please send a sample for us via OneDrive link so that we could try to investigate it for you.

    Best regards,

    Jazlyn

    0 comments