#1   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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   Report Post  
Posted to microsoft.public.excel.misc
Jay Jay is offline
external usenet poster
 
Posts: 671
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Quesiton Tina Excel Worksheet Functions 6 June 19th 07 12:15 PM
Update links box gives Continue or Edit Links dialog KarenF Excel Discussion (Misc queries) 0 May 18th 07 01:17 PM
Edit Links: Changing links on a protected worksheet Halibut68 Excel Discussion (Misc queries) 0 April 28th 06 11:03 AM
EXCEL - LINKS cannot easily get list of all links & names in book Tuba Joe Excel Worksheet Functions 1 September 29th 05 10:33 PM
If..then quesiton. Jeff Farrar Excel Worksheet Functions 3 November 2nd 04 06:38 PM


All times are GMT +1. The time now is 05:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"