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.

Security   An XML map and its data source information is saved with the workbook, not a specific worksheet. A malicious user could view this potentially sensitive map information by using a Microsoft Visual Basic for Applications (VBA) macro. Furthermore, if you save your workbook as an interactive Web page or as an XML workbook, this map information can be viewed through Notepad or through another text-editing program.

Delete the data source definition of the XML map from the workbook

If you want to keep using the map information but remove the potentially sensitive data source information, you can delete the data source definition of the XML schema from the workbook. In this case, you can still export the XML data.

Caution  This procedure permanently removes the current data source definition from the XML map.

1. On the Data menu, point to XML, and then click XML Map Properties.
2. Clear the Save data source definition in workbook check box.

   This option is selected by default. Clearing this option does not delete any data from the worksheet.

Important   The data source definition contains connection information about the imported XML data. Removing this information prevents others from viewing it, but you can still export the mapped data to an XML file. However, if you re-import the XML data file, the data source definition is once again saved with the file.

Delete an XML map from a workbook

If you delete a worksheet before deleting an XML map, the map information about the data sources and possibly other sensitive information is still saved in the workbook. If you are cleaning the workbook to remove sensitive information, make sure you delete the XML map before you delete the worksheet so that the map information is permanently removed from the workbook.

1. On the Data menu, point to XML, and then click XML Source.
2. In the XML Source task pane, click XML Maps.

   The XML Maps dialog box is displayed.

3. Select the XML map you want to delete.
4. Click Delete, and then click OK.

Note   Deleting an XML map only removes the XML map, it does not remove any data that the XML map is currently mapped to.