Hi,
I have linked two spreadsheets to auto populate through Vlookup, it works fine when the both spreadsheets are open, but the link doesn't work (gives Ref#) once the spreadsheet with the dynamic named range is closed. Any idea how to fix it?

Dynamic Named range is called: mp
Refers to: =OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A),8)

Vlookup formula in the other sheet: =IF(ISNA(VLOOKUP(B2,'\\share\shr\updates\Spreadsheet\S2.xls'!mp,8,FALSE)),"N/A",VLOOKUP(B2,'\\share\shr\updates\Spreadsheet\S2.xls'!mp,8,FALSE))

Let me know if I should include sample spreadsheets

Thanks in advanced!