Xml mapping
 

I need to export a stylesheet into an XML file from Excel 2003.
I created an XML Mapping on a template distributed to users.

The first time everything was OK, but I had to change my mapping and now
something unexpected happened.
Instead just mapping my columns to a map element as before, Excel create a
list.

Exporting is now a quite different story:

If the user want the export working it should now copy its data into the
list (the blue frame) and not outside
It must remember to adjust the size to its number of column or some data may
be lost
If the frame is longer than data I get blank element into the XML that make
the target application crash
If a column is blank the default into the schema is ignore and no element is
provided into the XML and the target application crash again

So, it's too difficult for a standard user and I have no time to make more
developments.


What can I do to make the mapping working as before?

thank you