Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Christchurch, Canterbury
    Posts
    122
    Thanks
    27
    Thanked 1 Time in 1 Post

    LInk to sheet changes (Word 2000)

    There is a large report which is linked to a number (18) spreadsheets with links. The doc gets passed around for additional comments by people who do not have access to the excel sheets. All links are locked.

    However, when the lower mortals save the doc it corrupts the links eg was:
    {LINK Excel.Sheet.8 SVR01ADMINNationalFinanceCommonReport1.xls FIN_RPT!R1C1:R20C20 p * MERGEFORMAT}
    and it becomes (say)
    {LINK Excel.Sheet.8 SVR01ADMINLocalReportsCommonReport1.xls FIN_RPT!R1C1:R20C20 p * MERGEFORMAT}

    Any ideas how to stop this happening? (No we don't want to give the PAs full access to the finance directories)

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: LInk to sheet changes (Word 2000)

    Hi Judith,

    One way would be to enclose the source file's path and name in a QUOTE field within the existing LINK field.

    To do this:
    . Select the field and press Shift-F9 to expose the code.
    . Select the source file's path and name (ie "SVR01ADMINNationalFinanceCommonReport1.xls FIN_RPT!R1C1:R20C20") and enclose it in a pair of double quotes (ie " ").
    . Press Ctrl-F9 to create a new field around the quoted source file's path and name, then type 'QUOTE' at the beginning of this field, such that you LINK field now looks like:
    {LINK Excel.Sheet.8 {QUOTE "SVR01ADMINNationalFinanceCommonReport1.xls FIN_RPT!R1C1:R20C20"} p * MERGEFORMAT}
    . Press F9 to update.

    Cheers
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    2 Star Lounger
    Join Date
    Nov 2003
    Location
    Christchurch, Canterbury
    Posts
    122
    Thanks
    27
    Thanked 1 Time in 1 Post

    Re: LInk to sheet changes (Word 2000)

    Thanks for that - we'll give it a try.

Posting Permissions

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