Link to Named Range in External File

J

Jason

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Importing named range from another workbook 5
Forumal writing for imported sheets 0
Using a changing cell reference as part of a workbook name 2 link 2
Macro in 2nd Open workbook 1
Combining sheets into one file 0
Update values in WkBk1 from WkBk2 1
STOP close button on another workbook 6

Top