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
MORE INFORMATION
Steps to Reproduce Problem
- Start a new project in Visual Basic. Form1 is created by default.
- 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.
- Set the SizeMode property of the OLE Client control to Autosize.
- Right-click the control, and select OPEN.
- 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