Only First Cell of MS Excel Worksheet Appears in Word 7.0

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:
  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 kbole
Version : WINDOWS:7.0,7.0a; Win95:7.0,7.0a
Platform : Win95 WINDOWS
Issue type :


Last Reviewed: January 3, 2000
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.