Thread: Excel help
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Excel help

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

On Tue, 20 Mar 2007 16:53:00 -0700,
wrote:

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