Layout limitations of XML lists

Note  XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

An XML list is created when you map a repeating XML element onto a worksheet. XML lists allow you to easily import, export, sort, filter, and print data based on an XML data source. However, XML lists do have some limitations regarding how they can be arranged on the worksheet.

XML lists are row-based, meaning that they grow from the header row downwards. You cannot add new entries above existing rows. You also cannot transpose an XML list so that new entries would be added to the right.