Tip #860: When export to Excel fails for no reason

Dynamics 365 is a temperamental mistress – everything is fine until it is not. Export to Excel has been working for a customer like a clockwork but then one day, without any warning, attempts to export this view:

Export records

started to generate this error:

Failed to generate Excel

(Clicking Show technical details would give some useless generic error with the invitation to contact system administrator a.k.a me)

Let me show the first screen again:

Export records with issue highlighted


While column names must be unique in Dynamics 365, nothing prevents customizer from creating two fields with the same Display Name. Everything seems to work fine but export to Excel dislikes duplicate column titles very much. Making the display name unique (per view basis at least) tamed the beast.

2 thoughts on “Tip #860: When export to Excel fails for no reason

  1. MrE says:


    I have seen this issue already (in CRM 2016 on premise) and believe that it might be related to Excell rendering the spreadsheet.



  2. Ryan Perry says:

    What fixes it when there are NOT any duplicate columns? Have run into this on an excel template that worked fine… until it didn’t.

Leave a Reply

Your email address will not be published. Required fields are marked *