XL2002: Excel Saves XML Files in the XML Spreadsheet Format

Article translations Article translations
Article ID: 287734 - View products that this article applies to.
This article was previously published under Q287734
Expand all | Collapse all

SYMPTOMS

When you save a file in the Extensible Markup Language (XML Spreadsheet) format, the file is not saved in a generic XML file format.

-and-

XML Spreadsheet (*.xml) is the only XML format listed in the Save As dialog box.

CAUSE

Microsoft Excel can save XML files in the XML Spreadsheet format. It cannot save workbooks in a different XML schema, including schemas that follow the XML Schema Definition (XSD) language proposed by the World Wide Web Consortium (W3C).

MORE INFORMATION

Microsoft Excel can open any XML file. If the XML file references an Extensible Style Language (XSL) file, Excel lets you choose whether to use that XSL file to transform the XML file, or to use the built-in XML flattener.

For additional information about how Excel opens XML files, click the article number below to view the article in the Microsoft Knowledge Base:
282161 XL2002: Opening XML Files in Excel
By default, XML files are opened as read-only. This leaves the original file unchanged for future use.

You can also create XML Spreadsheet files programmatically, by using either Microsoft Visual Basic Professional Edition for Windows, version 6.0, or Active Server Pages (ASP) technology.

For additional information about how to programmatically create an XML Spreadsheet file, click the article number below to view the article in the Microsoft Knowledge Base:
285891 HOWTO: Use Visual Basic or ASP to Create an XML Spreadsheet for Excel 2002

REFERENCES

For more information about the World Wide Web Consortium (W3C) and XML, please see the following W3C Web site:
http://www.w3.org/

Properties

Article ID: 287734 - Last Review: January 31, 2007 - Revision: 1.4
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbconversion kbprb KB287734

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com