Changing route directory of links across multiple files
Amazing chart utilities from Jon Peltier
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Changing route directory of links across multiple files

  1. #1
    Guest

    Default

     
    I have a number of excel files which are linked to files containing the raw data. I am moving all the files to a new directory. How can I change the route directories on the links without having to go into each file and change the link individually?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    2 options spring immediately to mind

    1) make sure all your files are open and then "save as" into their new respective directories (any links will auto-update themselves)

    2) on your files that were linked to (say) files in the old "personnel" directory which have now been moved to the new "finance" directory, just edit/replace the word "personnel" with "finance" on all sheets

    3) there might be a find/replace command in MS DOS, it's been a while since I used it where you can just replace old text with new text.... long shot though.


    :: Pharma Z - Family drugstore ::

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think you may also be a candidate for the Edit / Links menu item, where you can "change source," although each separate file would need to be updated individually. Find / replace (alt e e)would be my first choice.

    mb

  4. #4
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      


    [ This Message was edited by: NateO on 2002-03-13 14:25 ]

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com