ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   quesiton on links (https://www.excelbanter.com/excel-discussion-misc-queries/193581-quesiton-links.html)

Jay

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!

RagDyeR

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!



Jay

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!




RagDyeR

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