Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2014
    Posts
    1
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Relative links from Excel to Word

    I tried to follow macropod's advice at http://windowssecrets.com/forums/sho...External-Files but could not get it to work for me. Please help!!

    two word docs that link to cells in an Excel file in the same directory. On their own, they work. However, I want to have this same trio of files in seperate directories for each branch of the library system where I work. When I copy the files to these directories, the links go back to the original file. I would like them to go only to the excel file in the same directory.

    The link looks like { LINK Excel.Sheet.12 \\\\TPDC\\Users\\me\\Outreach\\OutreachSpreadsheet .xlsx KG!R31C3 \a \f 4 \h } (directory names changed). I tried adding '/ /' as I thought he intended to leave { LINK Excel.Sheet.12 / /OutreachSpreadsheet.xlsx KG!R31C3 \a \f 4 \h } but the files did not update.

    Can anybody help me fix this?

    Thanks

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    3,855
    Thanks
    0
    Thanked 177 Times in 163 Posts
    I don't know what you're doing, but it doesn't have any apparent connection with the advice in the Relative Links thread. It seems like you might be trying to do this through field coding, which the thread says cannot be done with LINK fields...
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Tags for this Thread

Posting Permissions

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