Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)

    I have a user who is getting an error on a specific cell in her spreadsheet: "Excel cannot calculate the formula. Cell references in the formula refer to the formula's result, creating a circular reference." I have attempted to use the Auditing toolbar to trace dependants, etc., but everything is checking out okay. I even went so far as to create a VB script to find the circular reference (as detailed in MS Knowledgebase article 213826) and it found nothing. Anyone ever seen this happen before? I would think the spreadsheet may be corrupt, but I'm not sure how to fix it.

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Satiria

    Welcome to the Lounge

    Try and use the "circular reference" toolbar to find the cells affected. See if this helps. It should come up automatically when MS-Excel finds this condition, but yet again why ask why?

    Hope this helps, if not post a reply

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)

    The macro they proposed will only work if all the precedents are on the same sheet as the circ reference. If the circular reference crosses sheets the macro will not work and it will find NOTHING.

    Trace the precedents/dependents manually by going to each sheet they reference it points to and trace the precedents/dependents. This should give a circular loop eventually.

    There is also a message in the bottom which tells what the circ reference is.

    Also check for reference to DEFINED NAMED ranges. The defined names do NOT trace that well and may also lead to circ references.
    Steve

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)

    Have tried using the precedent/dependent cells - everything checks out okay. Still wondering if the file isn't somehow corrupt. I found something on the knowledgebase about Service Releases. I was incorrect in my first post. This was plain Excel 2000. I'm attempting to install SR1 now - we'll see if that makes a difference. Any other suggestions, though, would be appreciated.

  5. #5
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Circular Reference error but no Circ. Ref. found (Excel 2000 SR1)

    Can you censor it and post it?
    -John ... I float in liquid gardens
    UTC -7ąDS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •