Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Thanked 0 Times in 0 Posts

    Word linked to Excel (2003)

    I have a 13 section, 300 question (sequentially numbered) audit, formatted in Excel.
    For each of the 13 sections, I have 13 separate Word doc's detailing on how to complete each audit Q.

    The problem arises when I need to add/delete a Q in the audit.
    How can I link the Excel Q#'s to the Word document(s) so that when I add or subtract a question in the Excel audit, all of the Q#'s, in all 13 Word documents are updated with their new Q#'s?

    Is this type of link possible?

    Thanks for any assistance you can provide..

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Word linked to Excel (2003)

    > For each of the 13 sections, I have 13 separate Word doc's

    So you have 13*13 = 169 "doc's"? <img src=/S/flee.gif border=0 alt=flee width=25 height=25>

    But seriously, you could copy a question number in Excel to the clipboard, then use Edit | Paste Special in Word. Select "Unformatted text" and click "Paste link", then click OK.
    However, inserting and deleting numbers in Excel will not have the effect you want, since the text in Word will be linked to a fixed cell in Excel.

Posting Permissions

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