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.

 

Advertisements

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

    Like

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s