All the documentation essentially says to copy from Excel and paste into the MS-Word document. When I do that, the formatting of the MS-Word table is so different from the Excel sheet that this method is practically worthless, especially for larger or more complex spreadsheets. For example, the individual cells are frequently expanded to two rows even for simple numbers. In addition, the size of the table frequently exceeds the page size of the MS-Word document. These MS-Word tables are extremely cumbersome to modify, requiring individual cell-by-cell adjustment. If complicated, the tables are so greatly mis-shapen that one cannot grab, move or modify the table, and it is entirely unusable. In these instances, I've taken to pdf-ing the Excel sheet, converting it to a jpg format, then inserting it as a picture into the Excel document. This has the advantage that a picture is easily scalable, and MS-Word handles picture insertions ten times better than it handles Excel tables. Incidentally, I never have this trouble with tables in PowerPoint or Publisher or (God help us all) WordPerfect. This leads me to believe that these difficulties are actually involved with Microsoft's structural vision of what should be done in MS-Word vs. the market segmentation for Publisher.
Or possibly, there is some other insertion or linking mechanism that works better. Can you tell me what's true?
Bookmarks