#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
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.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
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?
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?
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks