Posted 8 September 2017, 2:05 pm EST
We are exporting to Excel using the following where saveFlags are SaveCustomColumnHeaders and UseOOXMLFormat:
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!