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

See?

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.

Share on FacebookTweet about this on TwitterShare on Google+

One thought on “Tip #860: When export to Excel fails for no reason

  1. MrE says:

    Hi

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

    Cheers

    MrE

Leave a Reply

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