Only First Cell of MS Excel Worksheet Appears in Word 7.0 (138867)



The information in this article applies to:

  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 95 7.0a
  • Microsoft Word for Windows 95
  • Microsoft Word for Windows 95 7.0a

This article was previously published under Q138867

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.

WORKAROUND

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:
  1. In Word, click Object on the Insert menu.
  2. Click the Create From File tab.
  3. Select the worksheet and click OK.
  4. Select the Link To File check box. Click OK.
  5. Once the object is in Word, click it to select it and press DELETE.
  6. Repeat steps a through d to reinsert the worksheet. The second time you perform these steps, the worksheet is inserted correctly.

Modification Type:MinorLast Reviewed:8/17/2005
Keywords:kbinterop KB138867