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.



5 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.


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 )

Google+ photo

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

Twitter picture

You are commenting using your Twitter 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.