Just to add I think I need the complete file name where the sheet is now.

for example:

D:\Excel docs\[TestBook.xlsm]TestSheet

I have tried this and the defined name is not being picked up in any of the
fomulas where it is used.



"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.