We have a data window that retrieves about 250K rows.
When I try and export to XLSX , it runs for a while then blows up. It DOES Not have much formatting other than 3 total columns.
When I use TXT or the Save as formatted txt the file is almost 600K but saves.
I then load into excel and then save as .XLSX and the new file is now 85K
This has got to be an issue that others have encountered or just a bug.
I saw a another article with this exact issue and a stupid answer suggesting when the person saved, excel was truncating to 65K rows. That's NOT it. this is Excel 12 and I could see the rows in the spreadsheet I imported using the import wizard
I'm using the ANSCI default encoding.
Any help appreciated.