I have a template that references data in another workbook with the following
formula.

=IF(ISBLANK(B26)=TRUE,"",VLOOKUP(B26,Masterprice_C ONFIDENTIAL.xls!all_prices,MATCH(which_price,Maste rprice_CONFIDENTIAL.xls!plist_code,0),FALSE))

The named range all_prices refers to
=OFFSET(Prices!$A$1,0,0,MATCH("*",Prices!$A$1:$A$1 5000,-1),MATCH("*",Prices!$1:$1,-1))

When I open a new file based on the template I have to edit the links
because I am getting 'Error: Undefined or non-rectangular name'.

When I click on Open Source the linked file opens OK and when I go back to
the original the links have updated and the edit links dialog box has gone.

My formula results in #REF unless the linked file is actually open.

How can I stop this from happening? Is there some kind of problem with my
dynamic named range?