Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Cannot Edit Automation Objects in Microsoft Excel Viewer

XL2000: Cannot Edit Automation Objects in Microsoft Excel Viewer

View products that this article applies to.

This article was previously published under Q211818

↑ Back to the top

Symptoms

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

↑ Back to the top

Workaround

There is no workaround for this behavior in the Microsoft Excel 2000 Viewer. To edit an Automation object in an Excel 2000 workbook, you must open the workbook in Excel and edit the object there.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

In the Microsoft Excel 95 Viewer, you can edit Automation objects in a Microsoft Excel workbook. If you want to use an Excel 2000 workbook with the Excel 95 Viewer, you must save the Excel 2000 workbook in the Excel 95 format. To do this, follow these steps:
1.Start Microsoft Excel 2000.
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.

↑ Back to the top

Keywords: KB211818, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 211818
Revision : 3
Created on : 9/27/2003
Published on : 9/27/2003
Exists online : False
Views : 233