![]() |
quesiton on links
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 -- Cheers! |
quesiton on links
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 ! ----------------------------------------------------------------------------------------------- "Jay" wrote in message ... 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 -- Cheers! |
quesiton on links
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 -- Cheers! "RagDyeR" wrote: 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 ! ----------------------------------------------------------------------------------------------- "Jay" wrote in message ... 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 -- Cheers! |
quesiton on links
Good luck, and thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Jay" wrote in message ... 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 -- Cheers! "RagDyeR" wrote: 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 ! ----------------------------------------------------------------------------------------------- "Jay" wrote in message ... 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 -- Cheers! |
All times are GMT +1. The time now is 09:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com