We have excel 2003 and are trying to save out a "xml spreadsheet".  The mess of a file is created (sorry but why is it so diffiuclt for MS to save out clean proper tags like everyone else) but i notice rows which are completely blank or contain blank fields will have the particular XML tag completely removed.  The problem with this is Im expecting 7 columns when sometimes the column can be 5 or 3 or 7.  Is there any way to force excel to NOT remove blank fields from the XML file this way everyone contains the 7 tags to correspond with the 7 column fields in the excel file.

Thanks