Microsoft KB Archive/138867

From BetaArchive Wiki
Knowledge Base


Only First Cell of MS Excel Worksheet Appears in Word 7.0

Article ID: 138867

Article Last Modified on 8/17/2005



APPLIES TO

  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 95a
  • Microsoft Word 95 Standard Edition
  • Microsoft Word 95a



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.



Additional query words: 7.0 word95 word7 part partial incomplete missing contents sheet winword

Keywords: kbinterop KB138867