Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
how to insert and excel worksheet into a word document?
I am attempting to insert an excel worksheet into a word document. I've tried
the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
#2
|
|||
|
|||
Start Word and Excel. In Excel, open the worksheet, select the cells
you want to insert into Word, and press Ctrl+C to copy the cells to the Windows clipboard. Switch to Word. Click on Edit | Paste Special | Paste: As: Picture or Microsoft Excel Object | OK. If you paste as a picture into Word, the resulting Word file will be smaller, but the contents of the Excel picture cannot be edited. If you paste as a Microsoft Excel object into Word, the resulting Word file will be larger, but the Excel object can be edited from Word by double-clicking on the object. Daveybau wrote: I am attempting to insert an excel worksheet into a word document. I've tried the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
#3
|
|||
|
|||
This is a fine fine solution, to copy and paste, however, why not instead fix
the problem where Word will not let you do "File/Insert" and then insert an Excel file? I know there is a conversion tool that should recognize the file as Excel and convert it to a Word table, however we have over 100 computers where I work and only 1 does it correctly. Instead of a work around, is there a way to actually FIX the problem? "garfield-n-odie" wrote: Start Word and Excel. In Excel, open the worksheet, select the cells you want to insert into Word, and press Ctrl+C to copy the cells to the Windows clipboard. Switch to Word. Click on Edit | Paste Special | Paste: As: Picture or Microsoft Excel Object | OK. If you paste as a picture into Word, the resulting Word file will be smaller, but the contents of the Excel picture cannot be edited. If you paste as a Microsoft Excel object into Word, the resulting Word file will be larger, but the Excel object can be edited from Word by double-clicking on the object. Daveybau wrote: I am attempting to insert an excel worksheet into a word document. I've tried the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
#4
|
|||
|
|||
There is no Insert command under the File menu, so the problem
could be that you're doing it wrong. Once you figure out how to insert a file, then inserting an Excel file into Word is not a problem if the Excel32.cnv text converter is installed. JasonJ1052 wrote: This is a fine fine solution, to copy and paste, however, why not instead fix the problem where Word will not let you do "File/Insert" and then insert an Excel file? I know there is a conversion tool that should recognize the file as Excel and convert it to a Word table, however we have over 100 computers where I work and only 1 does it correctly. Instead of a work around, is there a way to actually FIX the problem? "garfield-n-odie" wrote: Start Word and Excel. In Excel, open the worksheet, select the cells you want to insert into Word, and press Ctrl+C to copy the cells to the Windows clipboard. Switch to Word. Click on Edit | Paste Special | Paste: As: Picture or Microsoft Excel Object | OK. If you paste as a picture into Word, the resulting Word file will be smaller, but the contents of the Excel picture cannot be edited. If you paste as a Microsoft Excel object into Word, the resulting Word file will be larger, but the Excel object can be edited from Word by double-clicking on the object. Daveybau wrote: I am attempting to insert an excel worksheet into a word document. I've tried the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
#5
|
|||
|
|||
Sorry, I meant Insert/File, not File/Insert.
I will investigate this "Excel32.cnv" but I have yet to see this listed in any of the help files regarding this problem. "garfield-n-odie" wrote: There is no Insert command under the File menu, so the problem could be that you're doing it wrong. Once you figure out how to insert a file, then inserting an Excel file into Word is not a problem if the Excel32.cnv text converter is installed. JasonJ1052 wrote: This is a fine fine solution, to copy and paste, however, why not instead fix the problem where Word will not let you do "File/Insert" and then insert an Excel file? I know there is a conversion tool that should recognize the file as Excel and convert it to a Word table, however we have over 100 computers where I work and only 1 does it correctly. Instead of a work around, is there a way to actually FIX the problem? "garfield-n-odie" wrote: Start Word and Excel. In Excel, open the worksheet, select the cells you want to insert into Word, and press Ctrl+C to copy the cells to the Windows clipboard. Switch to Word. Click on Edit | Paste Special | Paste: As: Picture or Microsoft Excel Object | OK. If you paste as a picture into Word, the resulting Word file will be smaller, but the contents of the Excel picture cannot be edited. If you paste as a Microsoft Excel object into Word, the resulting Word file will be larger, but the Excel object can be edited from Word by double-clicking on the object. Daveybau wrote: I am attempting to insert an excel worksheet into a word document. I've tried the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
#6
|
|||
|
|||
You should find this file in the TextConv folder on hard drive of
the one computer that "does it correctly". Just copy it to the corresponding folder on the other computers' hard drives. JasonJ1052 wrote: Sorry, I meant Insert/File, not File/Insert. I will investigate this "Excel32.cnv" but I have yet to see this listed in any of the help files regarding this problem. "garfield-n-odie" wrote: There is no Insert command under the File menu, so the problem could be that you're doing it wrong. Once you figure out how to insert a file, then inserting an Excel file into Word is not a problem if the Excel32.cnv text converter is installed. JasonJ1052 wrote: This is a fine fine solution, to copy and paste, however, why not instead fix the problem where Word will not let you do "File/Insert" and then insert an Excel file? I know there is a conversion tool that should recognize the file as Excel and convert it to a Word table, however we have over 100 computers where I work and only 1 does it correctly. Instead of a work around, is there a way to actually FIX the problem? "garfield-n-odie" wrote: Start Word and Excel. In Excel, open the worksheet, select the cells you want to insert into Word, and press Ctrl+C to copy the cells to the Windows clipboard. Switch to Word. Click on Edit | Paste Special | Paste: As: Picture or Microsoft Excel Object | OK. If you paste as a picture into Word, the resulting Word file will be smaller, but the contents of the Excel picture cannot be edited. If you paste as a Microsoft Excel object into Word, the resulting Word file will be larger, but the Excel object can be edited from Word by double-clicking on the object. Daveybau wrote: I am attempting to insert an excel worksheet into a word document. I've tried the obvious by using insert, file, etc., but that brings me to a box (file conversion) that is unreadable. any suggestions? please help! David |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert Excel data as a Word table and stay within margins | Tables | |||
How do I create & merge specific data base & master documents? | New Users | |||
Insert excel data into word via mail merge | Mailmerge | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables | |||
Insert Excel Worksheets into Word Document | Microsoft Word Help |