Greetings:

When using Excel 2003, how do I copy or move (or otherwise get) defined
names from one workbook to another intact? When I copy (or move) a sheet
from one workbook to another, the defined names go with it, but the defined
names' references changes. (For example, a defined name's range that
includes the sheet name "Sheet2" becomes "#Ref.") I need to do this often
and I have a great many defined names that I need to keep. (The sheets
have identical names in both workbooks).

Thank you,
JP