Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Relative file location for link to Excel

    I have a Word 2000 document that references a cell in an Excel 2000 spreadsheet. The contents of the LINK field look something like this:

    {LINK Excel.Sheet.8 "D:SAUNDERSIWSDATA INPUT 7.XLS" Summary!R7C2 a t * MERGEFORMAT}

    The Word file is located in the same folder as the spreadsheet and I'd like to be able to send them to someone else without having to update the link (actually a lot of similar links)

    The obvious thing to do would be to omit the path from the file name:

    {LINK Excel.Sheet.8 "DATA INPUT 7.XLS" Summary!R7C2 a t * MERGEFORMAT}

    but this gives an error "Error! Not a valid link".

    Is there a way around this?

    Ian.

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Relative file location for link to Excel

    Things are more complicated than I thought.

    When I copy the Word file to somewhere else, the Excel filename in the LINK field may or may not be updated to reflect the new location. I think (but I'm not sure!) that if I copy the Excel file and the Word file to the same folder, then Word will update the filename to the new folder. I'm not sure when or how. It may be that at some point Word looks for the Excel file in various places and updates the filename if it finds it.

    Does anyone know what process it uses?

    Ian.

Posting Permissions

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