Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    South Australia, Singapore
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link Excel document to Words and vice versa (97)

    I'm linking some Excel worksheets(source document) to Words. When I make any changes to the figures in Excel, the figures will be automatically updated in Words.

    When I try to make some changes in Words, the Excel worksheet will "pop" out when I double click on the Words document (however it will prompt me an error message if the source document is not stored in my PC). Is there any way where I can make changes in Words & the changes will be automatically updated in Excel and vice versa?

    Minyi <img src=/S/groan.gif border=0 alt=groan width=16 height=15>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Link Excel document to Words and vice versa (97)

    A link is always one way - from source to target. If you paste link an Excel table or chart into a Word document, Excel is the source and Word is the target. Changes in the Excel source will be reflected in the Word target, but not vice versa. Even though you can see the data in Word, they are still Excel data that must be edited 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
  •