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