quesiton on links

J

Jay

If I rename a directory or a workbook, are the links to other workbooks
automatically updated or does the path get corrupted?? I have a number of
workbooks that are linked and I want to duplicate the entire directory and
rename the main workbook. thanks in advance for your time and consideration
on this one. Jay
 
R

RagDyeR

Make sure *all* the WBs are *open* at the time of the change.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

If I rename a directory or a workbook, are the links to other workbooks
automatically updated or does the path get corrupted?? I have a number of
workbooks that are linked and I want to duplicate the entire directory and
rename the main workbook. thanks in advance for your time and consideration
on this one. Jay
 
J

Jay

That was it. although the workbooks were still linked to the original
workbook, all I did was open that one and "save as" into the new directory.
worked great. thanks again !!! I have to do this for 38 commodities, each
with 16 linked workbooks and then link those 38 workbooks into a master
workbook. wish me luck !!!! Jay
 

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

Top