A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Excel Table into a Word Doc



 
 
Thread Tools Display Modes
  #1  
Old May 6th, 2004, 07:53 PM
Kevin
external usenet poster
 
Posts: n/a
Default Excel Table into a Word Doc

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

  #2  
Old May 6th, 2004, 08:13 PM
DDM
external usenet poster
 
Posts: n/a
Default Excel Table into a Word Doc

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


"Kevin" wrote in message
...
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



  #3  
Old May 6th, 2004, 08:27 PM
Kevin
external usenet poster
 
Posts: n/a
Default Excel Table into a Word Doc

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


"Kevin" wrote in

message
...
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



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.