How do I get the data/xml/export option

N

Nick

My export option is disabled under data/xml tab. What is the exact feature I
need to install to get this export xml option. I didn't install all the
option during excel installation. Which specific install tab are required
during excel installation?

thanks
Nick
 
P

Peo Sjoblom

One way would be to do a web query, first preformat the cells as text, then
do the query (data>import external data>new web query), put in the web site
address, select the part you want to import, under properties select
preserve cell formatting and do the import

--
Regards,

Peo Sjoblom

(No private emails please)
 
Top