Dynamics Community Forum Thread Details

Dynamics 365 "Failed to Generate Excel" error

Hello, colleagues.

I get an error of import and export data in CRM.

When I try to save some view or a result of advanced find in Excel, I get the next message:

«Failed to Generate Excel. An error occurred when Dynamics 365 tried to generate the Excel file. If this problem persists, contact your system administrator».

It happens permanently about 1 time per week. When it appears, it affects all the 3 CRM instances on the shared server at once. After IIS reset it disappears, but later appears again.

When the error appears, we also cannot do out-of-the-box import from a file: the next message appears (something like, by memory): «Error. Repeat this action again. If this problem persists, address the MS Dynamics 365 Community or MS Dynamics 365 administrator…».

And, it is not that well-known error, when there are two columns with the same name in your view (checked)).

CRM version is Microsoft Dynamics 365 9.0 On-premise.

Could you please be so kind to let me know how to find the reason of the error or how to customize CRM server to get rid of it?