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
Bookmarks