XL97: Cannot Edit Automation Objects in Microsoft Excel Viewer

ID: Q168973


The information in this article applies to:
  • Microsoft Excel, version 97 Viewer


SYMPTOMS

If you have a Microsoft Excel 97 workbook open in the Microsoft Excel 97 Viewer, you may not be able to edit any Automation objects that are in the open workbook.


WORKAROUND

There is no work around for this behavior in the Microsoft Excel 97 Viewer. To edit an Automation object in a Microsoft Excel 97 workbook, you must open the workbook in the Microsoft Excel 97 program and edit the object there.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

In the Microsoft Excel 95 Viewer, you can edit Automation objects in a Microsoft Excel workbook. If you want to use a Microsoft Excel 97 workbook with the Microsoft Excel 95 Viewer, you must save the Microsoft Excel 97 workbook in the Microsoft Excel 95 format. To do this, follow these steps:

  1. Start Microsoft Excel 97.


  2. Open the workbook that needs to be saved in the Microsoft Excel 95 format.


  3. On the File menu, click Save As.


  4. In the Save As Type box, select Microsoft Excel 5.0/95 (*.xls), and then click Save.


Additional query words: XL97 xlviewer

Keywords : kbtool kbviewer
Version : :97
Platform : WINDOWS
Issue type : kbbug


Last Reviewed: November 8, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.