I tried using the =with the workbook, worksheet and range name. I also tried
doing the instructions you gave me in your previous post but that did not
change the destination when I inserted an additional row in the souce range
list.
--
none


"Debra Dalgleish" wrote:

In the destination workbook, choose DataImport External DataNew
Database Query
Click on Excel Files as the data source, and click OK
Select the workbook with the list, and click OK
In the Query Wizard, select your named range, and click the button, to
add the columns to the query
Click Next, three times, then click Finish.
Select a starting cell for the imported list, and click OK

Right-click a cell in the imported list, and click Data Range Properties
Add a check mark to Refresh Data on File Open, and click OK.


RHall wrote:
I have a list with a range name in one worksheet that I would like linked to
another workbook. The list from the destination workbook needs to print on a
report. Excel 2002


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html