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.

1. Select a cell in the XML list.
2. On the Data menu, point to XML, and then click XML Map Properties.
3. Do one or more of the following:

   Adjust column width  

   • To automatically adjust column widths for best fit when you refresh XML data, select this option. This is the default.

     Note   The maximum column width is two-thirds the width of the screen.

   • To prevent automatic adjustment of column widths for best fit when you refresh XML data, clear this option.

   Preserve column filter  

   • To preserve autofiltering when you refresh XML data, select this option. This is the default.
   • To ignore autofiltering when you refresh XML data, clear this option.

   Preserve number formatting  

   • To preserve number formatting when you refresh XML data, select this option. This is the default.
   • To ignore number formatting when you refresh XML data, clear this option.