+ Reply to Thread
Results 1 to 2 of 2

Circular Reference Error Even Though There Is No C.R.

  1. #1
    MDW
    Guest

    Circular Reference Error Even Though There Is No C.R.

    Some of my colleagues are getting "circular reference" errors upon opening
    some Excel (2003) workbooks. I can open those same workbooks (also using
    Excel 2003) and I have no problem.

    The cell being identified as having a c.r. has the following formula:
    =sheet2!L16

    The cell sheet2!L16 has the following formula:
    =+'T:\Folder\[external_file.xls]summary_report'!M41

    On the external file, cell M41 is a simple value with no fomulas or anything.

    Any ideas what could be causing this problem?
    --
    Hmm...they have the Internet on COMPUTERS now!

  2. #2
    Valued Forum Contributor Excelenator's Avatar
    Join Date
    07-25-2006
    Location
    Wantagh, NY
    Posts
    333
    Is it possible they have another workbook open that contains the circular reference? The error message for circular references appears as long as the workbook containing the CR is open even if you toggle to another open workbook which would give the appearance that the workbook you are viewing has the CR. Just a thought.


    Quote Originally Posted by MDW
    Some of my colleagues are getting "circular reference" errors upon opening
    some Excel (2003) workbooks. I can open those same workbooks (also using
    Excel 2003) and I have no problem.

    The cell being identified as having a c.r. has the following formula:
    =sheet2!L16

    The cell sheet2!L16 has the following formula:
    =+'T:\Folder\[external_file.xls]summary_report'!M41

    On the external file, cell M41 is a simple value with no fomulas or anything.

    Any ideas what could be causing this problem?
    --
    Hmm...they have the Internet on COMPUTERS now!
    ---------------------------------------------------
    ONLY APPLIES TO VBA RESPONSES WHERE APPROPRIATE
    To insert code into the VBE (Visual Basic Editor)
    1. Copy the code.
    2. Open workbook to paste code into.
    3. Right click any worksheet tab, select View Code
    4. VBE (Visual Basic Editor) opens to that sheets object
    5. You may change to another sheets object or the This Workbook object by double clicking it in the Project window
    6. In the blank space below the word "General" paste the copied code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1