07-18-2014 04:21 AM
We have a customer running Saleslogix v8 LAN, with Office 2010 (32 bit). On one of their machines 'Export to Excel' always fails with the error message:
Error creating Excel work book object:
Excel cannot open the file 'grp-My Accounts.XLSX' because the file format or file extension is not valid. Verify that the file has not been corrupted and that hte file extension matches the format of the file.
Taking a look at the output directory I can see the Excel file has been created by Saleslogix however when attempting to open it we see the same error message above. Attempting to open the file on another machine results in the same error message.
I have tried a reinstallation of Salelsogix and a repair of Office however the error still persists, even when logged into the PC and Saleslogix as the administrator.
07-18-2014 04:25 AM
07-18-2014 04:31 AM
The error is occuring on all groups regardless of the row count, I have tried groups with just one or two rows and still have the same issue.
By editing the format are you refering to changing the file extension in the SLX_Export_Group_To_Excel script?