Show All
Troubleshoot XML import and export errors
Note XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.
When I add an XML map to my workbook, a message tells me the the XML schema cannot be added to my workbook.
There are several types of XML schema constructs that Microsoft Office Excel 2003 does not support. The following list details the XML schema constructs that cannot be imported into Excel :
<any> The <any> elements allows you to include elements that are not declared by the schema.
<anyAttribute> The <anyAttribute> elements allows you to include attributes that are not declared by the schema.
Recursive structures Excel does not support recursive structures that are more than one level deep.
Abstract elements Abstract elements are meant to be declared in the schema, but never used as elements. Abstract elements depend on other elements being substituted for the abstract element.
Substitution groups Substitution groups allow an element to be swapped wherever another element is referenced. An element indicates that it's a member of another element's substitution group through the <substitutionGroup> attribute.
Mixed content Mixed content is declared using mixed="true" on a complex type definition. Excel does not support the simple content of the complex type, but does support the child tags and attributes defined in that complex type.
When I export XML data, a message tells me that the XML maps in my workbook are not exportable
The contents of an XML mapping cannot be exported under the following circumstances:
- An XML mapping cannot be exported if the mapped element’s relationship with other elements cannot be preserved. This relationship may not be preserved for the following reasons:
- The schema definition of a mapped element is contained within a sequence with the following attributes:
- The maxoccurs attribute is not equal to 1.
- The sequence has more than one direct child element defined, or has another compositor as a direct child.
- Non-repeating sibling elements with the same repeating parent element are mapped to different XML lists.
- Multiple repeating elements are mapped to the same XML list, and the repetition not defined by an ancestor element.
- Child elements from different parents are mapped to the same XML list.
- The XML mapping contains one of the following XML schema constructs:
- List of lists One list of items contains a second list of items.
- Denormalized data An XML list contains an element that has been defined in the schema to occur once (the maxoccurs attribute is set to 1). When you add such an element to an XML list, Excel fills the list column with multiple instances of the element.
- Choice This is a mapped element that is part of a <choice> schema construct.
When I save my workbook as XML Data, a message tells me that Excel cannot save the workbook because it does not contain any XML mappings.
Excel cannot save all or part of your workbook as XML Data if you have not created one or more mapped ranges. If you haven't added an XML map to your workbook, or your data is not contained within an XML list, then you can save your workbook in the XML Spreadsheet file format.
If you have added an XML map to your workbook, follow these steps to map XML elements to your worksheet:
- On the Data menu, point to XML, and then click XML Source to open the XML Source task pane.
- To map one or more elements to your worksheet, select the elements in the XML Source task pane. To select nonadjacent elements, click one element, and then hold down CTRL and click each element.
- Drag the selected elements to the worksheet location where you want them to appear.