I have a fairly large workbook with worksheets that contain a lot of
formulas and named ranges that reference other worksheets in the
workbook. I'd like to be able to make templates based on two of the
worksheets, but when I copy them out of the workbook and try to use
them that way, I run into problems because copying them always results
in a link back to the workbook they came from, and besides that, the
named ranges seem to get converted to named ranges that are local to
the worksheet, which I don't want.

Aside from what I've been doing, which is taking the new template,
deleting all of its local named ranges and links, and then adding it to
the workbook, is there another way this can be handled? I'm running
into this problem increasingly often, and the method I'm using is
pretty slow and inefficient. Can anyone offer some advice?