Microsoft KB Archive/129793

= Excel Displays Only First Column in Embedded Worksheet =

Article ID: 129793

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Visual Basic 5.0 Control Creation Edition
 * Microsoft Visual Basic 5.0 Learning Edition
 * Microsoft Visual Basic 4.0 Standard Edition
 * Microsoft Visual Basic 5.0 Professional Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 4.0 Professional Edition
 * Microsoft Visual Basic 5.0 Enterprise Edition
 * Microsoft Visual Basic 4.0 32-Bit Enterprise Edition
 * Microsoft Visual Basic 4.0 16-bit Enterprise Edition

-



This article was previously published under Q129793





SYMPTOMS
Microsoft Excel displays only the first column in an Auto-Formatted multiple-column worksheet object embedded from a file. This problem occurs when the instance of Microsoft Excel that is opened is subsequently closed. This behavior is exhibited by both the 16-bit and 32-bit versions of Microsoft Excel version 5.0.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

151261 OFF97: How to Obtain and Install MS Office 97 SR-2



Steps to Reproduce Problem

 * 1) Start a new project in Visual Basic. Form1 is created by default.
 * 2) Add an OLE Client control to Form1. Select the Create From File check box in the Insert Object dialog, and specify a previously saved .XLS file that contains a Auto-Formatted worksheet with more than one column of data. Click OK, and note that the entire spreadsheet is displayed.
 * 3) Set the SizeMode property of the OLE Client control to Autosize.
 * 4) Right-click the control, and select OPEN.
 * 5) Exit from Microsoft Excel.

The first column of the spreadsheet is displayed in a stretched format, but the control retains its same size. Because SizeMode = Autosize, the entire spreadsheet should be displayed but it is not.

Keywords: kbbug kbinterop kbprogramming KB129793

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.