+ Reply to Thread
Results 1 to 4 of 4

#ref vlookup error

  1. #1
    Registered User
    Join Date
    02-21-2011
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question #ref vlookup error

    Hi
    I am finding a strange error message in Excel 2010 which I didn't encountered in previous versions.

    I have entered a vlookup function referring to other excel file. The command as below
    =VLOOKUP($A2,'G:\Chart of Accts\[Account groupings.xlsx]all coa'!$A:$F,2,FALSE)
    When I open the referrred file(Account Groupings.xls) the formula reference automatcially change to #REF. You can see the changed formulae below.
    =VLOOKUP($A2,'G:\Chart of Accts\[Account groupings.xlsx]#REF'!$A:$F,2,FALSE)

    Can someone help.

    Regards

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: #ref vlookup error in Excel 2010 when referred file opened

    Welcome to the forum!

    Are you saying that you used these same two files in previous versions of Excel with no problem?

    Did you confirm that Account groupings.xlsx actually has a worksheet called "all coa"?

    Can you attach the two files? I do not have 2010 but can confirm whether 2007 and 2003 handles them properly.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    02-14-2012
    Location
    Denver
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: #ref vlookup error in Excel 2010 when referred file opened

    Hi -- I'm having this problem, as well. Rather, I'm not, but my boss is.

    We have two files, with one linked to the other. If she opens the file with the data and then the file with the links, everything is fine. If she opens the file with the links, and then the file with the data, all the links have reference errors as described above. I can open the files in any order with no problems, as can another coworker. Since it's user specific, I would think that it's a setting, but I can't determine which one.

    Assiduous googling hasn't led to any clues -- does anyone have any ideas?

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: #ref vlookup error in Excel 2010 when referred file opened

    Welcome to the Forum, eulerfan!

    New questions are generally required to be posted to a new thread, but it looks like you have almost the same question. But to clarify, are you finding that the formula itself is being updated, or just that the cell displays a #REF error?

    Even if it is user specific, there are a lot of variables. Does you boss have the same OS? Version of Excel? Folder structure? Are you opening local copies on your own disks, or accessing the same files over a network?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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