Link to Named Range in External File
 

Hi,

I have to workbooks, workbook1 and workbook2.
I have a named range in workbook2.
In workbook1 I used the get external data feature to link to the named range
in workbook2.

When i refresh the data in workbook1, it opens workbook2. Is it possible to
refresh the data in workbook1, and it refresh from workbook2, without it
automatically opening workbook2?

Thanks, appreciate your help.

Jason