How to use a name defined in an excel file to another excel file

[cr_ashok]

I have defined a name for a data range in an excel file. Now I want to use the same name in different excel file. I tried through various sources but not sure how to do that.
Current Soln: I am copying the data from the source file and re-defining the names for the range. But this seems to be duplicate and creates unnecessary space.
Please let me know a good approach for this.

 

[alvin-chung]

Assume that you'd defined a name "xyz" in book1.xlsx, try use "book1!xyz" in book2.xlsx and that should works.

 

[cr_ashok]

Assume that you'd defined a name "xyz" in book1.xlsx, try use "book1!xyz" in book2.xlsx and that should works.

Thanks a lot.... It works

 

[alvin-chung]

You're most welcome