Exported Excel2007 file appears to think it is Excel2003 when opened in Excel and resaved

Posted by: j2associates on 8 September 2017, 2:05 pm EST

  • Posted 8 September 2017, 2:05 pm EST

    Hello all,

    We are exporting to Excel using the following where saveFlags are SaveCustomColumnHeaders and UseOOXMLFormat:

    FpSpread1.SaveExcel(exportPath, saveFlags)

    ExportPath includes the extension xlsx and appears to be created correctly using a table with 120,000+ records in it. When you open the file in Excel, all of the records are there and can be browsed, etc. But, if you make a change anywhere in the file and try to save it, you get the following error message, which speaks of significant loss of data and functionality. The message refers to Excel 2003 row and column limits. Thanks in advance for any ideas and/or suggestions!

  • Replied 8 September 2017, 2:05 pm EST

    Brain cramp alert! The computer running the application was in compatibility mode.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels