Search all of Office.com
 
Support / Excel / Excel 2003 Help and How-to / Working with Data
 
 

Working with XML

Add, map, and unmap XML elements

Article Add, map, and unmap XML elements Add, map, and unmap XML elements Note XML features, except for saving files in the XML Spreadsheet format, are...

Append or overwrite mapped XML data

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Change the query for XML data imported from a Web service

Article Click a cell on the worksheet containing XML data that was imported from a Web service. On the Data menu, point to XML , and then click Edit Query ...

Delete XML map information from a workbook

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft pnOfficePro11 and Microsoft pnExcel11...

Export XML data

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft pnOfficePro11 and Microsoft pnExcel11...

Features and limitations of XML Spreadsheet format

Article When you save an Microsoft Excel worksheet in XML Spreadsheet format, many Excel features are retained, but some are not. Details are listed in the following...

Format the data and layout of an XML list

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Hide the blue border of a single-mapped cell or XML list

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

How to use XML in Excel 2003

Article Show All Hide All Applies to Microsoft Office Excel 2003  Note    The information in this article assumes that you have a basic knowledge of Extensible...

Import XML data

Article Show All Hide All  Note     XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition...

Refresh XML data

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Rename an XML map

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Troubleshoot XML

Article Show All Hide All  Note    XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition...

Turn around expense reports in a snap with Excel 2003 and XML

Article Show All Hide All By Mark Gillis Applies to Microsoft Office Excel 2003 Two words that may make you run for cover: expense reports. You dread them, you...

Unsupported XML schema constructs

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Validate XML data against an XML schema

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft pnOfficePro11 and Microsoft pnExcel11...

XML for the uninitiated

Article You may have heard of Extensible Markup Language (XML), and you may have heard many reasons why your organization should use it. But what is XML, exactly...

XML Schema Definition (XSD) data type support

Article Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft...

Working with XML data in a worksheet

Article Applies to Microsoft Office Excel 2003 This article was adapted from Microsoft Office System Inside Out, 2003 Edition by Michael J. Young and Michael Halvorson...