Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Quesiton | Excel Worksheet Functions | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Edit Links: Changing links on a protected worksheet | Excel Discussion (Misc queries) | |||
EXCEL - LINKS cannot easily get list of all links & names in book | Excel Worksheet Functions | |||
If..then quesiton. | Excel Worksheet Functions |