Unable to update links
 

Problem...
2 spreadsheets in different folders. One "Postcodes.xls" provides a
postcode/town lookup range for the spreadsheet "Data.xls". So, in DATA you
enter the postcode & a lookup searches down th erange "PCDS" within POSTCODES
to find a match.
However, when POSTCODES is not open, the lookup fails & returns #REF.

As soon as POSTCODES is open, the #REF resolves to the correct values.

The range PCDS is dynamically named using the OFFSET function

If I delete the dynamic range & set it as a static range, everything works
as it should!

Any suggestions/ideas why this happens & is there a way to get around it &
still use dynamic ranges?

Cheers
Colin Foster