Excel Table into a Word Doc

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

I know this is more of a Word question but . . . I have a
small table in Excel that I want to input into Word. Now
I know that I can cut and paste, but that gets to be a
pain in the butt when I need to update the excel table and
then recopy and repaste it into Word. I'm wondering if
there is anyway to link the two files together so that any
changes made in the excel file will be automatically
reflected in the Word Doc? I would just edit the Word
Doc, but the table has a formula in it. I don't know if
it's possible to enter a formula in Word or if it will
just take it as text.

Any light on the idea would be greatly appreciated.

Kevin
 
Kevin, copy the Excel table, then in Word, Edit > Paste Special > Excel
Worksheet Object > Paste Link > OK.

Update in Excel, it updates in Word. From Word, double-click the cells, it
takes you to Excel, where you can edit. Pretty cool, huh?
 
Thanks for the tip. It works beautifully.

-----Original Message-----
Kevin, copy the Excel table, then in Word, Edit > Paste Special > Excel
Worksheet Object > Paste Link > OK.

Update in Excel, it updates in Word. From Word, double- click the cells, it
takes you to Excel, where you can edit. Pretty cool, huh?
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com





.
Click to expand...
 
Back
Top