Only First Cell of MS Excel Worksheet Appears in Word 7.0

ID: Q138867

The information in this article applies to:

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

Last Reviewed: February 6, 1998