Dynamics GP Smart List Export to Excel found a problem with content, repaired records
After moving to from Office 13 to 365 the following error appears when users export from Dynamics GP smart lists to Excel.
We found a problem with some content in 202222-1232S9.XISX. Do you want us to try to recover as much as we can? If you trust the source of this workbook, cick yes
Followed by
Excel was able to open the file by repairing or removing the unreadable content.
Repaired Records Format from /xl/styles.xml part (Styles)
The file generated as a log says pretty much the same thing
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error491840_01.xml</logFileName>
<summary>Errors were detected in file ’C:\Users\***\AppData\Local\Temp\202222-123259.XLSX’</summary>
<repairedRecords>
<repairedRecord>Repaired Records: Format from /xl/styles.xml part (Styles)</repairedRecord>
</repairedRecords>
</recoveryLog>
By adding the following line somewhere in the Dex.Ini file (normally in the Data subfolder of the application folder of GP), resolved the issue in this case.
SmartlistEnhancedExcelExport=TRUE
This ini switch is not compatible with the GP web client if you are using that.
References:
Undocumented DEX.INI switch cuts down SmartList export times to Microsoft Office Excel