CRM 2016 – Failed to generate excel

There is an odd bug which I found when I selected all the fields on an opportunity record in an advanced find and then tried to export the records to excel.

Data import error 2

What made this error annoying was the download log file was greyed out, so it was difficult to investigate.

The reason for the error is because there are two fields with the same Display name, in this case it was two fields with the name Proposed Solution.

excel error

To resolve the error you need to rename one of the fields and you will be able to export from Excel again.

You could also not select the duplicate fields and this will work around the error.



7 thoughts on “CRM 2016 – Failed to generate excel

  1. Koen vdv July 1, 2016 / 7:23 am

    FYI: This error occurs on every entity if you have two fields with the same Display name.


  2. Syed September 8, 2017 / 9:24 am

    Hosk, thanks a lot it worked, It saved me a lot of time in a time critical situation . I always appreciate the good work that you do. Keep it up fellow CRMer.


  3. Natalia Llano Prades February 8, 2018 / 8:21 pm

    Today we have the same problem in our project.

    We have tried this solution, but unfortunately, it has not worked. Neither a problem with the number of records to export.
    Finally, we have discovered the problem, a value in a picklist has been deleted!! When you re-create the value in the picklist (with the same id, of course) the problem has been solved magically. I hope you help them


  4. Anuj May 6, 2019 / 1:34 am

    You are a gem man…. Thanks for helping us all in critical situations.
    Anuj Govil


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.