The SAS® Merchandise Intelligence 5.41 client will not export to Microsoft Excel 2016 XLS or XLSX in Windows Server 2022


The following error might occur in the SAS Merchandise Intelligence client distudio.log for SAS® Size Optimization or SAS® Revenue Optimization Suite when you try to export to Microsoft Excel 2016 XLS or XLSX in Windows Server 2022:

ERROR Worker-4: Export to Excel Format com.sas.solutions.di.commons.export.XlsExportingJob - Exporting to XLS failed. Fallback to CSV format