You don't say which version and edition of Excel you are running.
From Excel 2003 help.
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.