Export XML

[Guest]

Trying to export a spreadsheet as XML.
From the Help menu of excel I read:

Export XML data
On the Data menu, point to XML, and then click Export.

MY PROBLEM IS THAT IN MY DATA MENU the option XML does not appear.
I am using Excel 2003 (SP2) but as part of MS Office Basic, could this be
the problem? I though that all I need is Excel 2003...
Do I have to "activate" some sort of add in in Excel in order to view the
XML option under the Data menu?

Thanks

 

[Debra Dalgleish]

The XML feature is only available in the Office Professional Edition
2003. There's version information on the Microsoft web site:

http://www.microsoft.com/office/editions/prodinfo/compare.mspx#EAAA

 

[Guest]

Hi,
I'm getting the same problem, but could not find any relevant clue from your
answer.
I've downloaded the 2003 trial version from this site today.
Again my question is:

On the Data menu, point to XML, and then click Export.

MY PROBLEM IS THAT IN MY DATA MENU the option XML does not appear.

 

[David Biddulph]

"Debra Dalgleish" wrote:

Hi,
I'm getting the same problem, but could not find any relevant clue from
your
answer.
I've downloaded the 2003 trial version from this site today.
Again my question is:

On the Data menu, point to XML, and then click Export.

MY PROBLEM IS THAT IN MY DATA MENU the option XML does not appear.

If you've got the wrong version of Excel and don't get that option under the
Data menu, have you tried File/ Save As/XML ?

http://office.microsoft.com/en-gb/assistance/HP010425731033.aspx