Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have a document with over 200 pages that is linked to various files in Excel - all of them as "Excel Worksheet Object'. The only thing that ever changes is the parent folder year (see file folder path examples below). I was wondering if there is anyway to quickly update the document to reflect the current path rather than going into each link and doing it manually.

    Old Path: S:\Departments\Admin Services\Department\Budget\2008-09 Budget
    Current Path: S:\Departments\Admin Services\Department\Budget\2009-10 Budget

    I've attached a small sample so it's a bit clearer to understand.

    Thanks.
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    See macropod's star post Post 261488, it contains a document with a macro to update the path of LINK fields (and others).

  3. #3
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you for the tip. That is one great macro that I can totally put to use! As a FYI to others, it turns the Reviewing toolbar on automatically and sets it to Track Changes everytime the doc is opened.

    For this particular project though, it's not working very well (most likely due to the size of the doc itself since Word keeps crashing). Anyway to simply do a Find/Replace on the field codes/links to update all instances of 08-09 to 09-10 instead?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    You could try the following:
    - Press Alt+F9 to display field codes.
    - Press Ctrl+H to activate the Replace dialog.
    - Replace all instances of 08-09 with 09-10.
    - Press Alt+F9 to hide field codes.
    - Press Ctrl+A to select the entire document.
    - Press F9 to update all fields.

    With a large document, you may want to save it after each step so that you don't lose too much if Word crashes.

  5. #5
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you. I will try this again. Didn't do the last step the last time I tried it.

Posting Permissions

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