How do I fix External Cell reference in Excel-2007?

How do I fix External Cell reference in Excel-2007? I have two spreadsheat files (D:\Book1.xlsx and D:\Book2.xlsx). The first workbook has a table, Table1 with three columns (id, Name, Value). In the second work book I to want reference values in Table1 using VLOOKUP. My current formula for referencing values is
Asked by: Guest \| Views: 354

Total answers/comments: 1

Comments display order:

bert [Entry]

"This looks to me like a bug in Excel. I can reproduce the behavior as well, but I have all options related to external data enabled and valid. This includes all options in the Trust Center Settings and all workbook references listed in External Links. Manually updating values from External Links doesn't do it, either.

I've also followed the instructions in this MS Support article. It works to an extent, but everything reverts to the behavior you note after I close."