1 Reply Latest reply: May 15, 2014 10:05 AM by Itech _ RSS

    Another Monarch 10 to Excel 2007 problem

    Itech _

      We have an existing project and model that previously exported data to an .xls spreadsheet.  The spreadsheet was recently converted to a .xlsm file.  The export ran ok, but when the spreadsheet is opened in Excel the following message is displayed: Excel found unreadable content in 'file.xlsm'.  Do you want to recover the contents of this workbook? 


      If I click Yes to the message, Excel opens the spreadsheet but the page is blank.  Excel also displays a new message box with 'Replaced Part: /xl/worksheets/sheet2.xml part with XML error.  Load error. Line 1, column 265.'

        • Another Monarch 10 to Excel 2007 problem
          Itech _

          We found the cause of this problem.  There were several worksheets in the workbook we were exporting to.  The other worksheets had styles and formulas in them.  Some of the cells with not marked as locked.  When Monarch exports to a workbook with cells that are not locked, cell styles that are not locked and all subsequent cell styles are deleted.  Since the styles were missing the file didn't open correctly. 


          The work around is to make sure all cells are marked locked.