You will need to quote the full path name in the destination Workbook.

For example:-

1. I have the following Range Name in file called:-

C:\steve\Gotroots3

The Range Name is:-

a1toa3namerange

- found in cells A 1 to A3 of Sheet1.

2. In a file called:-

C:\excel\microsoft\Gotroots2

I have the following in cells A 1 to A 3 of Sheet1:-

='C:\steve\[Gotroots3.xlsx]Sheet1'!$A$1
='C:\steve\[Gotroots3.xlsx]Sheet1'!$A$2
='C:\steve\[Gotroots3.xlsx]Sheet1'!$A$3

Basically you must quote the full path name to access the correct Range Name.

If my comments have helped please hit Yes.

Thanks.



"Gotroots" wrote:

I created a define name range on a sheet of certain worksheets in the
workbook. Many of those sheets have now been moved to other workbooks and as
a result the Name range is no-longer working. What way do I add the external
workbook name and its sheet name.

Thank you for any help.