I have a workbook that pulls descriptions from a linked file when an item number is keyed into a cell. Every time the file is opened, I get the message that 'one or more of the links in this workbook cannot be updated. Yet the data appears to be correct for every item I key in.
I have clicked on edit and there is only one file connected to it (as it should be) both files are saved as xlsx files and I am running Excel 2010. I am searching in named ranges in the link file using an INDEX/MATCH lookup.