External References working in Excel 2003, but not Excel 2007

[Dandini8497]

I have created a Summary spreadsheet that uses external references to obtain core data from a CSV (comma separated values) file, as well as using VLOOKUP's to do translations of abbreviations from the CSV file via an external reference to another Excel workbook containing a table (column A is the abbreviations, column B is the plain english). My formula's may not be the prettiest, but they work. All is fine when viewed in Excel 2003, including if i make a change to the RefTable workbook, however when viewed in Excel 2007, all works fine, but if i modify the RefTable workbook, the summary does not update as it does when viewed in excel 2003.

Here is the primary function:
=VLOOKUP(Buildings.csv!AW2,[RefTable.xls]Table!$A$2:$B$600,2,FALSE)

this statement references the data from buildings.csv, then compares it to the reftable, finds an exact match in column A, and finally results in the cell showing the plain text found in column B from the reftable.

as i said, this all works fine in Excel 2003, but does not update when opened in excel 2007.

This is the actual cell contents, same as above only makes it place ??? in the cell if the abbreviation found is not on the reftable, also leaves cell blank if the corrosponding cell in the csv file is blank.

=IF(Buildings.csv!AW2<>"",IF(ISNA(VLOOKUP(Buildings.csv!AW2,[RefTable.xls]Table!$A$2:$B$600,2,FALSE)),"???",VLOOKUP(Buildings.csv!AW2,[RefTable.xls]Table!$A$2:$B$600,2,FALSE)),"")

I realize i'm not great at working my issue, but i hope that is a good enough description to solve my issue. i have been at this for 3 days and have been getting increasingly frustrated.

 

[xenou]

I don't see any reason why this wouldn't work - are you still having trouble? Why three different file types (csv, xls, xlsx)?