Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to embed an Excel Table (not worksheet) into word?
|
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Pat,
Copy the range of cells in the Excel workbook. Move the insertion point in the Word document to the location where you want to insert the range of cells. Click Paste on the Edit menu. Double-click the embedded Excel object (the range of cells you copied in Excel and pasted into Word) to edit in Excel. There is, of course no link between the Excel workbook and the Word document. If you want to link the the workbook so changes in the workbook are reflected in the Word document, click Paste Special on the Edit menu, click the Paste Link radio button, click Microsoft Excel worksheet object and OK' Jon "Pat-WordQuestions" wrote in message news |
#4
|
|||
|
|||
I tried this, and it didn't work. Not only did the cells not automatically
sum when I entered a different amount in one of the fields, but I tried to double-click on the table, and it wouldn't take me to Excel, so I could edit it there. Evidently I'm not doing this right. "Jon Weaver" wrote: Pat, Copy the range of cells in the Excel workbook. Move the insertion point in the Word document to the location where you want to insert the range of cells. Click Paste on the Edit menu. Double-click the embedded Excel object (the range of cells you copied in Excel and pasted into Word) to edit in Excel. There is, of course no link between the Excel workbook and the Word document. If you want to link the the workbook so changes in the workbook are reflected in the Word document, click Paste Special on the Edit menu, click the Paste Link radio button, click Microsoft Excel worksheet object and OK' Jon "Pat-WordQuestions" wrote in message news |
#5
|
|||
|
|||
How did you do the paste? Normally Word will paste a selected object as
such, unless you tell it otherwise. But if that didn't work, try using PasteSpecial. "Pat-WordQuestions" wrote in message ... I tried this, and it didn't work. Not only did the cells not automatically sum when I entered a different amount in one of the fields, but I tried to double-click on the table, and it wouldn't take me to Excel, so I could edit it there. Evidently I'm not doing this right. "Jon Weaver" wrote: Pat, Copy the range of cells in the Excel workbook. Move the insertion point in the Word document to the location where you want to insert the range of cells. Click Paste on the Edit menu. Double-click the embedded Excel object (the range of cells you copied in Excel and pasted into Word) to edit in Excel. There is, of course no link between the Excel workbook and the Word document. If you want to link the the workbook so changes in the workbook are reflected in the Word document, click Paste Special on the Edit menu, click the Paste Link radio button, click Microsoft Excel worksheet object and OK' Jon "Pat-WordQuestions" wrote in message news |
#6
|
|||
|
|||
When you paste data from Excel, it's pasted into Word as a Word table, not
an Excel object. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Jezebel" wrote in message ... How did you do the paste? Normally Word will paste a selected object as such, unless you tell it otherwise. But if that didn't work, try using PasteSpecial. "Pat-WordQuestions" wrote in message ... I tried this, and it didn't work. Not only did the cells not automatically sum when I entered a different amount in one of the fields, but I tried to double-click on the table, and it wouldn't take me to Excel, so I could edit it there. Evidently I'm not doing this right. "Jon Weaver" wrote: Pat, Copy the range of cells in the Excel workbook. Move the insertion point in the Word document to the location where you want to insert the range of cells. Click Paste on the Edit menu. Double-click the embedded Excel object (the range of cells you copied in Excel and pasted into Word) to edit in Excel. There is, of course no link between the Excel workbook and the Word document. If you want to link the the workbook so changes in the workbook are reflected in the Word document, click Paste Special on the Edit menu, click the Paste Link radio button, click Microsoft Excel worksheet object and OK' Jon "Pat-WordQuestions" wrote in message news |
#7
|
|||
|
|||
Pat,
Jezebel is right! I get inconsistent results using Paste. As she suggested, click Paste Special and select Microsoft (Office) Excel worksheet object. Make sure the Paste radio button is selected and not the Paste link button. Jon "Jezebel" wrote in message ... How did you do the paste? Normally Word will paste a selected object as such, unless you tell it otherwise. But if that didn't work, try using PasteSpecial. "Pat-WordQuestions" wrote in message ... I tried this, and it didn't work. Not only did the cells not automatically sum when I entered a different amount in one of the fields, but I tried to double-click on the table, and it wouldn't take me to Excel, so I could edit it there. Evidently I'm not doing this right. "Jon Weaver" wrote: Pat, Copy the range of cells in the Excel workbook. Move the insertion point in the Word document to the location where you want to insert the range of cells. Click Paste on the Edit menu. Double-click the embedded Excel object (the range of cells you copied in Excel and pasted into Word) to edit in Excel. There is, of course no link between the Excel workbook and the Word document. If you want to link the the workbook so changes in the workbook are reflected in the Word document, click Paste Special on the Edit menu, click the Paste Link radio button, click Microsoft Excel worksheet object and OK' Jon "Pat-WordQuestions" wrote in message news |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert Excel data as a Word table and stay within margins | Tables | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
WORD 2000 pages layout when EXCEL table inserted | Page Layout | |||
Export table data to Excel | Tables | |||
Table link to Excel | Tables |