How do you copy and rename linked worksheets?

I have several worksheets that are linked together. At times I would like to
copy the worksheets over in the same folder and would also like to rename it.
However the links are to the orginal worksheets not the renamed worksheets

How can I change linked worksheet names and still maintain the links with
the renamed worksheets?

You manage your linked files through the menu Edit - Links.



"Phil 51" wrote:

> I have several worksheets that are linked together. At times I would like to
> copy the worksheets over in the same folder and would also like to rename it.
> However the links are to the orginal worksheets not the renamed worksheets
>
> How can I change linked worksheet names and still maintain the links with
> the renamed worksheets?