XL2002: Error Message: The Following Features from Your Workbook Will Not Be Saved in the XML Spreadsheet (287739)



The information in this article applies to:

  • Microsoft Excel 2002

This article was previously published under Q287739

SYMPTOMS

When you try to save a workbook in the XML Spreadsheet format, you may receive an error message similar to the following:
The following features from your workbook will not be saved in the XML Spreadsheet:

* AutoShapes, other objects, or charts
* VB project

Do you want to continue saving as an XML Spreadsheet?

CAUSE

The XML Spreadsheet format cannot save various types of objects and data.

MORE INFORMATION

When you save an Excel workbook in XML Spreadsheet format, the following types of objects and data are not saved with the file:
  • OLE objects (such as embedded documents or objects from another program)
  • Pictures
  • Drawings and AutoShapes
  • Charts
  • Microsoft Visual Basic for Applications (VBA) projects
  • Group and outline information
  • Custom e-mail envelope information
  • Custom named styles that are not being used by any cell in the workbook

REFERENCES

For more information about the XML Spreadsheet format, click Microsoft Excel Help on the Help menu, type xml spreadsheet in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

Modification Type:MajorLast Reviewed:2/26/2002
Keywords:kberrmsg kbprb KB287739