Hey guys,

I have been struggling with this problem for a while and hope that you can help me solve this.

I have written a web service that returns well formed XML including schema etc. I verified both the XML and the schema and they are both fine.
Within Excel, I am importing this XML using
ThisWorkbook.XmlImport url, Nothing, True, worksheet.Cells(1, 1)

So far no problem, I can import the data and it is displayed properly.

The only issue is that if there is only one object (or row) in the XML, the nicely formated headers that allow filtering etc disappear! However, I do need those headers in my sheet (especially since I want to know what data is being displayed in the column).

I assumed that Excel would parse the schema and see where my maxOccurs are unbounded to understand that there would be multiple elements. It does not, apparently.

If anybody could help me solve this issue, I would be for ever grateful... :)

Cheers,
Che