Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Help and How-to
Search
Search
 
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Rename an XML map
 

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 you add an XML map to a workbook, Excel provides default XML map names in the following way: Root_Map, Root_Map1, Root_Map2, and so on. To avoid confusion, you may want to provide more meaningful names to the XML map, especially if you are working with more than one XML map.

  1. On the Data menu, point to XML, and then click XML Source.
  2. In the XML Source task pane, click XML Maps.
  3. Click the XML map you want to rename.
  4. Click Rename.
  5. Type the new name, and then press ENTER.
  6. Click OK.

    The new name is displayed in the XML maps in this workbook list box at the top of the XML Source task pane.

Note   Because element names are based on the XML schema file (.xsd) or the inferred schema that Excel creates when you don't have an XML Schema file, you cannot change the element names after you create an XML map.

advertisement