insert excel spreadsheet

[KRK]

Hello

I have a Word document into which I want to insert an Excel spreadsheet. I
want to be able to update the spreadsheet and have the word document update
at the same time. I also want to be able to print the word document with the
excel data shown as a table.

I think this is possible, but I cannot find the route.

I have excel 2007 and word 2007

Thanks

KK

 

[Amish]

Copy your Excel data
Paste into Word using the Paste Special/Paste Link option

 

[Brandon G]

Hi KRK,

This is possible so all you have to do is open both the excel and word
documents. Select the range of cells you want to show in the word document,
then copy the selected cells and then in the word document and place your
cursor where you want to put the data. In the menu bar select Edit-> Paste
Special. After you do that a dialog box shows up and you just click the paste
button and select Excel worksheet object from the list, and then hit OK.

To update the spreadsheet and word document at the same time all you have to
do is copy and paste the data from excel to word. After you paste there
should be a paste options button in the lower right hand corner of your data,
click the down arrow and select Match Destination Table Style and Link to
Excel link and that's it.

Hope this Helps!

Brandon G.

 

[Terry Farrell]

And note that you MUST insert the link IN LINE or the link will not update.

 

[KRK]

Thanks for the help,

KK