Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Linking Excel to Word
Hi:
Is it possbile to link an excel spreadsheet to a word document so that you can update the excel document and have the information automatically update on the word document? I created a hyperlink between the two documents but when I update the excel sheet the word document does not change. I really appreciate any help I can get on this problem becuase my boss needs this for a project. Thanks! |
#2
|
|||
|
|||
Hi
Yes, you can do this. There are several variations on how to do it, but this is my preferred method: 1. In Excel, select the area of the spreadsheet you want and do Edit Copy. 2. In Word, do Edit Paste Special. Tick the box that says you want to Link the data, and choose to paste as a Picture (Enhanced Metafile). 3. When you want to edit the Excel part, open Excel and make your changes to the file there. When you go back to Word, it will have updated automatically. Note that you can only paste one 'page' full at a time. There is no way to take a large Excel spreadsheet and have Word spread it over several pages. Hope this helps. Shauna Kelly. Microsoft MVP. http://www.shaunakelly.com/word "erin_montgomery" wrote in message ... Hi: Is it possbile to link an excel spreadsheet to a word document so that you can update the excel document and have the information automatically update on the word document? I created a hyperlink between the two documents but when I update the excel sheet the word document does not change. I really appreciate any help I can get on this problem becuase my boss needs this for a project. Thanks! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Please give us REVEAL CODES like WORD PERFECT not reveal codes in. | Microsoft Word Help | |||
Envelope Address | New Users | |||
Wordperfect Office 2000 conversion to Word 2003 | New Users | |||
Linking Excel cell to Word problem | Microsoft Word Help | |||
Boiletplates from Word Perfect | Microsoft Word Help |