How do you copy and rename linked worksheets?

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HOW DO I COPY AND RENAME A WORKBOOK LINKED TO OTHER WORKBOOKS 1
Copy folder with excel linked workbooks 1
Sorting in multiple worksheets 1
Linked cells between worksheets and sorting 2
Cells act as if they are linked-link does not display in entry bar 1
How keep links when copy worksheets to another file? 2
Worksheet renaming 5
Paste Values in linked Cells Only 4

Top