Err Msg: "Word Cannot Edit the Microsoft Excel Worksheet"

ID: Q114321

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c

SUMMARY

When you edit a Microsoft Excel Worksheet object in Microsoft Word for Windows, after you install Microsoft Excel version 5.0 over Microsoft Excel version 4.0, you receive the following error message:

Word cannot edit the Microsoft Excel Worksheet

If you then convert the object to a Microsoft Excel 5.0 Worksheet object, when you edit the object, you receive the following error message:

Word cannot edit the Microsoft Excel 5.0 Worksheet

CAUSE

This behavior occurs if the following entry is missing from the Microsoft Excel Worksheet key in your REG.DAT file:


   AutoConvertTo={00020810-0000-0000-C000-000000000046}

This entry is added when you run the Microsoft Excel version 5.0 Setup program, and is needed to convert a Microsoft Excel Worksheet object (inserted from Microsoft Excel version 4.0) to a Microsoft Excel 5.0 Worksheet object so that you can edit the object in Microsoft Excel version 5.0. If for any reason this entry is no longer present in the REG.DAT file, the above behavior occurs when you edit or convert a Microsoft Excel version 4.0 object.

Note that similar behavior occurs with a Microsoft Excel Chart or Macro sheet object.

WORKAROUND

To correct this behavior, you must run the Microsoft Excel 5.0 Setup program to first remove Microsoft Excel version 5.0, and then reinstall it on your computer. You must run the Setup program because the AutoConvertTo entry is only added when you run the Setup program. This entry is not automatically added when you run Microsoft Excel, or when you merge the EXCEL5.REG file into the REG.DAT file.

MORE INFORMATION

A similar error message appears when you edit a Microsoft Excel Worksheet object under the conditions described above in another Windows application, such as Microsoft PowerPoint, Microsoft Access, or Microsoft Project.

Additional query words: 5.00c 6.00 6.00a officeinterop

Keywords :
Version : 5.00 5.00c
Platform : WINDOWS
Issue type :