Results 1 to 2 of 2
2003-05-07, 09:59 #1
- Join Date
- May 2003
- South Australia, Singapore
- 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>
2003-05-07, 11:24 #2
- Join Date
- Mar 2002
- 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.