Excel Displays Only First Column in Embedded Worksheet (129793)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95
  • Microsoft Excel for Windows 5.0
  • Microsoft Visual Basic Control Creation Edition for Windows 5.0
  • Microsoft Visual Basic Learning Edition for Windows 5.0
  • Microsoft Visual Basic Standard Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition for Windows 5.0
  • Microsoft Visual Basic Professional Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Professional Edition, 16-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition for Windows 5.0
  • Microsoft Visual Basic Enterprise Edition, 32-bit, for Windows 4.0
  • Microsoft Visual Basic Enterprise Edition, 16-bit, for Windows 4.0
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

  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.
Modification Type:MinorLast Reviewed:10/10/2006
Keywords:kbbug kbinterop kbProgramming KB129793
©2004 Microsoft Corporation. All rights reserved.