Microsoft KB Archive/87377

{|
 * width="100%"|

WinWord 2.0: Can't Add New Cells to Excel Worksheet Object
'Article ID: Q87377

Creation Date: 29-JUL-1992

Revision Date: 09-SEP-1996' The information in this article applies to:


 * Microsoft Word for Windows, versions 2.0, 2.0a, 2.0a-CD, 2.0b 2.0c, 6.0, 6.0a, 6.0c
 * Microsoft Excel for Windows, versions 3.0, 4.0, 4.0a

SUMMARY

Choosing the Paste Special command in Microsoft Word for Windows to paste an Excel worksheet object created in Microsoft Excel for Windows can prevent you from adding new cells to the worksheet when you later update the Excel worksheet object. If you change information in the original range of cells, those changes are reflected when you update the object and return to Word for Windows. However, if you add cells to the worksheet, these new cells are not included in the Excel worksheet object when you update the object and return to Word for Windows.

MORE INFORMATION

Workaround

To work around this problem, do not choose the Paste Special command to embed Excel worksheet objects in Word for Windows documents. Instead, choose Object from the Insert menu, select the Microsoft Excel Worksheet option, and choose the OK button.

Steps to Reproduce Problem


 * 1) Launch version 3.0 or 4.0 of Microsoft Excel for Windows.
 * 2) Open a worksheet (.XLS) file in Excel.
 * 3) Select a range of cells. From the Edit menu, choose Copy.
 * 4) Switch to or launch Word for Windows. From the Edit menu, choose Paste Special.
 * 5) Under Data Type, select Microsoft Excel Worksheet Object, then choose the Paste button.
 * 6) Double-click the embedded object to open it in Microsoft Excel for Windows for editing. Change the information in some of the existing cells, and add information to some blank cells outside the original range selected in the worksheet.
 * 7) From the File menu, choose Exit. Choose the Yes button when prompted to update the object.

The information in the cells that were part of the original object are updated correctly; however, the information added to new cells does not appear in the embedded object result. If you now double-click the Excel worksheet object to launch Excel again, the worksheet appears, and the original range of cells is selected. The information added to new cells in step 6 is not selected.
 * }

-

"THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED &quot;AS IS&quot; 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." '' ©1997 Microsoft Corporation. All rights reserved. Legal Notices.

''

KBCategory: kbinterop

KBSubcategory:

Additional reference words: 2.00 2.00a 2.00a-cd missing not included

word6 winword winword2 6.00 6.00a 6.00c 2.00c