Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2007

Tip: Looking for answers? Try searching our database.

Excel help

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
j_m_craig@yahoo.com - 21 Mar 2007 00:53 GMT
How can i create a table in excel and display the table in a word document.  
I need the table to update as the data in the excel doc changes
Gord Dibben - 21 Mar 2007 01:03 GMT
From help in MS Word on "link to excel"

Select the data or chart you want to copy.
Click Copy .
Switch to Microsoft Word or Microsoft PowerPoint.
Click in the document or presentation where you want to put the Microsoft Excel
data or chart, and do one of the following:
Paste the data into Word

Click Paste  on the Formatting toolbar (toolbar: A bar with buttons and options
that you use to carry out commands. To display a toolbar, click Customize on the
Tools menu, and then click the Toolbars tab.).
Click Paste Options  next to the data, and then do one of the following:
To paste the data as a Word table, click Match Destination Table Style or Keep
Source Formatting.

Note this part*************************************

To paste a link to the Excel data, so that the data in the Word document is
updated whenever you change the data in the original Excel workbook, click Match
Destination Table Style and Link to Excel or Keep Source Formatting and Link to
Excel.

End Note*****************************************
To paste the data as text with each row in a separate paragraph and tabs
separating the cell values, click Keep Text Only.

Gord Dibben  MS Excel MVP

>How can i create a table in excel and display the table in a word document.  
>I need the table to update as the data in the excel doc changes
j_m_craig@yahoo.com - 21 Mar 2007 01:42 GMT
I need more specific instructions please, I am using xp

> From help in MS Word on "link to excel"
>
[quoted text clipped - 27 lines]
> >How can i create a table in excel and display the table in a word document.  
> >I need the table to update as the data in the excel doc changes
Gord Dibben - 21 Mar 2007 03:47 GMT
Can't get much more specific than...........copy the range to Word and "Link to
Excel" when you paste but you may have trouble if you don't have the Show Paste
Options Button appear.

Make sure in Word you have Tools>Options>Edit "Show Paste Options Button"
checkmarked.

After pasting click on that button and select one of the two "Link to Excel"
options.

Gord

>I need more specific instructions please, I am using xp
>
[quoted text clipped - 29 lines]
>> >How can i create a table in excel and display the table in a word document.  
>> >I need the table to update as the data in the excel doc changes
BoniM - 21 Mar 2007 01:07 GMT
Create and save the table in excel.  In word, place your insertion point
where you want the excel table to go and then choose insert, object from the
menu bar or ribbon.  This will open a dialog box - choose create from file
and then browse to select the appropriate file.  Check link to file and click
okay.  Your excel table should now be displayed in your word document and
will update as excel does, or each time you open the word doc.  Be aware that
if you link files and need to transport or transmit the file containing
links, make sure to include the link source file as well.  

> How can i create a table in excel and display the table in a word document.  
> I need the table to update as the data in the excel doc changes
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.