Only First Cell of MS Excel Worksheet Appears in Word 7.0

Last reviewed: February 6, 1998
Article ID: Q138867
The information in this article applies to:
  • Microsoft Excel for Windows 95, versions 7.0, 7.0a
  • Microsoft Word for Windows 95, versions 7.0, 7.0a

SYMPTOMS

When you embed a Microsoft Excel 7.0 object in Word, only the first cell of the worksheet appears.

STATUS

Microsoft has confirmed this to be a problem in Word for Windows 95 version 7.0. Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

WORKAROUNDS

There are several ways to work around this problem.

Method 1: Close the worksheet in Microsoft Excel before trying to insert it

          as an object in Word.

Method 2: Instead of using the Insert Object feature in Word, copy the
          worksheet in Microsoft Excel to the Clipboard and then paste it
          into Word. It will still come in as an embedded object.

Method 3: The following procedure will also correct the problem if it is
          necessary that the file be open in Microsoft Excel:

          a. In Word, click Object on the Insert menu.

          b. Click the Create From File tab.

          c. Select the worksheet and click OK.

          d. Select the Link To File check box. Click OK.

          e. Once the object is in Word, click it to select it
             and press DELETE.

          f. Repeat steps a through d to reinsert the worksheet. The
             second time you perform these steps, the worksheet is
             inserted correctly.


KBCategory:
KBSubcategory:
Additional reference words: 7.0 word95 word7 part partial incomplete
missing contents sheet winword
Keywords : kbinterop kbole
Version : 7.0 7.0a
Platform : WINDOWS


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 6, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.