+ Reply to Thread
Results 1 to 3 of 3

Inserting Excel Spreadsheets into MS-Word Documents

  1. #1
    Registered User
    Join Date
    01-11-2014
    Location
    Las Vegas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Inserting Excel Spreadsheets into MS-Word Documents

    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?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-11-2014
    Location
    Las Vegas
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Inserting Excel Spreadsheets into MS-Word Documents

    Replying to my own question-- I am searching documentation and see the right-click method in MS-Word of choosing the format of an Excel sheet to be pasted into the document. It still doesn't answer the question, because only the picture paste method starts to be usable. Thus we can't link spreadsheets to MS-Word documents, or even have them continue to calculate, because the formatting of pasted documents is so poor that it takes hours to produce a roughly equivalent MS-Word table. I also tried inserting an OLE Excel object, but find the formatting problem remains. So I've searched high and low through the documentation trying to get an acceptable method to do this, but haven't yet found one. Is there some smart user out there who knows a work-around method? Thank you.... Bruce Isaacson

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,230

    Re: Inserting Excel Spreadsheets into MS-Word Documents

    My suggestions,
    1. The sheet P&L Cons has three sections; put them on separate tabs.
    2. With BOTH the Excel file and a blank Word document open, insert three blank pages into the word document then select LANDSCAPE orientation.
    3. In Excel, select only the used table cells of the first tab (do not select the whole worksheet). Copy.
    4. On the first sheet of the Word document select Paste Special --> Paste Link --> MSO Excel Worksheet Object

    You can update the tables in the Word document by right clicking them and selecting Update Links.
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Populating Word from excel and other word documents
    By Higham in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-01-2013, 09:06 PM
  2. [SOLVED] Inserting data from table in Word template and create wod/pdf documents
    By SteinerKD in forum Word Programming / VBA / Macros
    Replies: 4
    Last Post: 02-28-2013, 11:08 AM
  3. Inserting multiple excel files into multiple word documents
    By lwaldron in forum Word Programming / VBA / Macros
    Replies: 11
    Last Post: 10-02-2012, 05:34 AM
  4. [SOLVED] Print errors with Word documents in Excel spreadsheets
    By mike-ss in forum Excel General
    Replies: 0
    Last Post: 08-10-2005, 01:05 PM
  5. [SOLVED] Finding Words In Excel Spreadsheets & Word Documents
    By rbonner79416 in forum Excel General
    Replies: 0
    Last Post: 03-18-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1