Import XML to new page does not work, but to same page it does. Why?

Hi and thanks for having a look at my issue. I use Excel 2007.

I am importing xml from a webpage using get external data > from other sources > from xml data import. The page is:

The import data dialog now opens. When I choose “import to xml table in existing worksheet” (first option), all is good. But if I choose the third option, “new worksheet”, the result is gibberish compressed into two lines.

Why does one way work perfectly and the other way not?

Thanks in advance, Mat

By: mathias nagy

Leave a Reply

Your email address will not be published. Required fields are marked *