Questions

Circular Reference Warning

Tags:
+
0 Votes
Locked

Circular Reference Warning

J.Runn
Hello,

I have a user that is getting an errror message when she attempts to open a excel spreadsheet she works on every week. She has a Dell Latitude D630 with XP Pro and Office 2007 fully updated. Spreadsheet is saved to 97-03 compatibility.

When she trys to open the spreadsheet the circular reference warning error appears. If i press cancel to create a circular reference, the error window goes away but the workbook/spreadsheet doesn't appear. It is blank. I'm not a 100% sure if its supposed to be a circular reference or not, it is an insurance document so there are a good amount of formulas wrriten.

She was able to work on this last week. Now she can't, I'll find out what she might have changed last week.

Thanks for the help!
  • +
    0 Votes

    A circular reference is created if you enter a formula into a cell that links directly or indirectly to itself.

    A circular reference is just a formula that depends on its own value.

    There should not be any circular references in your workbooks unless you specifically want them to be there.

    If you receive a circular reference warning when you are not expecting one it means that the formula has been entered incorrectly.

    These can be created very easily (often by mistake). Just link cell B2 to cell B3 and then link cell B3 to cell B2.

    More on the subject here:
    http://www.bettersolutions.com/excel/EUZ139/VC827516332.htm

    Please post back if you have any more problems or questions.
    If this information is useful, please mark as helpful. Thanks.

    +
    0 Votes
    J.Runn

    Now, she can't open up any of her spreadsheets. Do you know what is causing this, and how to resolve this major issue?

    On the first spreadsheet I tried to delete the formula because I just wanted to see the workbook. After I deleted the formula I still couldn't see the workbook. I have steps on how to fix this through Microsoft but since I can't see the workbook or work with it, I can't find a way to fix this issue.

    Thanks!

    +
    0 Votes
    J.Runn

    The other workbooks are showing different symptoms. There is only the first one showing the circula reference error message. When the user trys to open the other spreadsheets, nothing opens up. No error code, no new workbook. Just an empty excel window with toolbars.

    +
    0 Votes

    Please post back if you have any more problems or questions.
    If this information is useful, please mark as helpful. Thanks.

    +
    0 Votes

    Yes

    J.Runn

    But, I have already read that website.

    We just deleted the formula in that cell and then saved it. We opened it again and set the formula once again. Resolved.

    Thanks

    +
    0 Votes
    hgasko

    I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?

    +
    0 Votes

    Try re-posting in the Q&A
    section as a new question. You can submit a question to 'Q&A' here:

    http://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

    There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

    Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer". .

    +
    0 Votes
    hgasko

    I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?

  • +
    0 Votes

    A circular reference is created if you enter a formula into a cell that links directly or indirectly to itself.

    A circular reference is just a formula that depends on its own value.

    There should not be any circular references in your workbooks unless you specifically want them to be there.

    If you receive a circular reference warning when you are not expecting one it means that the formula has been entered incorrectly.

    These can be created very easily (often by mistake). Just link cell B2 to cell B3 and then link cell B3 to cell B2.

    More on the subject here:
    http://www.bettersolutions.com/excel/EUZ139/VC827516332.htm

    Please post back if you have any more problems or questions.
    If this information is useful, please mark as helpful. Thanks.

    +
    0 Votes
    J.Runn

    Now, she can't open up any of her spreadsheets. Do you know what is causing this, and how to resolve this major issue?

    On the first spreadsheet I tried to delete the formula because I just wanted to see the workbook. After I deleted the formula I still couldn't see the workbook. I have steps on how to fix this through Microsoft but since I can't see the workbook or work with it, I can't find a way to fix this issue.

    Thanks!

    +
    0 Votes
    J.Runn

    The other workbooks are showing different symptoms. There is only the first one showing the circula reference error message. When the user trys to open the other spreadsheets, nothing opens up. No error code, no new workbook. Just an empty excel window with toolbars.

    +
    0 Votes

    Please post back if you have any more problems or questions.
    If this information is useful, please mark as helpful. Thanks.

    +
    0 Votes

    Yes

    J.Runn

    But, I have already read that website.

    We just deleted the formula in that cell and then saved it. We opened it again and set the formula once again. Resolved.

    Thanks

    +
    0 Votes
    hgasko

    I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?

    +
    0 Votes

    Try re-posting in the Q&A
    section as a new question. You can submit a question to 'Q&A' here:

    http://www.techrepublic.com/forum/questions/post?tag=mantle_skin;content

    There are TR members who specifically seek out problems in need of a solution. Although there is some overlap between the forums, you'll find more of those members in 'Q&A' than in 'Discussions' or 'Water Cooler'.

    Be sure to use the voting buttons to provide your feedback. Voting a '+' does not necessarily mean that a given response contained the complete solution to your problem, but that it served to guide you toward it. This is intended to serve as an aid to those who may in the future have a problem similar to yours. If they have a ready source of reference available, perhaps won't need to repeat questions previously asked and answered. If a post did contain the solution to your problem, you can also close the question by marking the helpful post as "The Answer". .

    +
    0 Votes
    hgasko

    I have a file which Excel thinks has a circular reference. I have set the options to Manual calculation and 1 iteration and opened the file and clicked CANCEL to allowthe circular reference. Excel appears to do nothing - the screen stays blank. However when I try to close Excel, it asks if I want to save changes to the file, implying it is open. Also, when I use VBA to look at the project, the file and its sheets are there. So it is open - it just is not displaying it. How can I get at the file in order to remove the circular reference?