0 Replies Latest reply: May 15, 2014 9:54 AM by pams_cf _ RSS

    Export/Append to Excel-last line not formatted

    pams_cf _

      I am exporting summaries to Excel. The first model creates the file and it is fine. The next model appends but the last line loses its formatting so the next model gets the error "data type in destination table does not match data type in export". The last line has the numbers as default font and general format whereas the alpha data is formatted to my font. All lines are formatted except the last line.  It is not a total line. There are blank fields exported. Version 8.02 Excel 2003. Have export set to Excel 97+ formatted.