Issue
After a Sigma Flexima has exported a CSV text file and then when opened in Windows Excel an error message occurs ‘File not loaded completely’
Environment
Sigma Flexima, Microsoft Excel 2003
Cause
Occurs because the Flexima export file contains more data than Windows Excel can load into one worksheet. Microsoft Excel 2003 is limited to 65665 lines of data; this is equivalent to a Flexima file size of approximately 1.5Mb.
Resolution
Reduce the size of the export file by running more frequent Flexima extractions from the Sigma Scheduler.
Microsoft Excel 2007 or later has an increased capacity to 1,048,576 rows. Upgrade the excel version will resolve the issue.