View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
hans bal(nl)
 
Posts: n/a
Default How do you copy and rename linked 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?