Error message when trying to export to excel

(0) Share

Report

Posted on by Community Member

3326.error-message.PNG

I keep getting this message when I'm trying to export to excel. It doesn't matter if I'm trying to export a static or dynamic worksheet I keep getting this. Sometimes I'm able to export, but recently I haven't been able to for about 2 weeks now.

*This post is locked for comments

All responses (6)

Answers (2)

Gampi Reddy 87 on at

Like (0)

Report

RE: Error message when trying to export to excel

Hi Francesco Picchi,

I am exporting account entity it contains more than 20K records with all Columns. Could you please let me know is there any issue if i add all columns.

Thanks You & Best Regards

Gampi Reddy.
Suggested answer

Community Member on at

Like (0)

Report

RE: Error message when trying to export to excel

This happens when you have two identical column headings that are the same. Typically, you get two column headings of SUBJECT when you list Service Activities.
dmitrii pivovarov 10 on at

Like (0)

Report

RE: Error message when trying to export to excel

Another cause of the problem might be that the SQL cannot load the data on its RAM due to the Size of the results.

This is mostly seen on an On-Premises CRM installations and the solution to this problem is to export the data using XRM-toolbox.
Verified answer

Community Member on at

Like (0)

Report

RE: Error message when trying to export to excel

Hi Maximillian,

if you solved the problem thanks to an answer, please mark it as verified to encourage the community to provide more and more a better support. Thank you. Francesco

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com
Verified answer

Community Member on at

Like (0)

Report

RE: Error message when trying to export to excel

Hi Maximillian,

please check:

1) you havent selected many columns (eg. all salesorderdetail columns for 30.000 records)

2) you havent included in columns two fields with the same label

Please let me know.

If you found the answer helpful, please mark as Verified

Join my network on LinkedIn Follow me on Twitter

Thank You & Best Regards

Francesco Picchi

Microsoft Dynamics CRM Consultant, Bologna+Milano, ITALY

Independent Contractor

http://www.francescopicchi.com
KylieKiser 2,174 on at

Like (0)

Report

RE: Error message when trying to export to excel

Is this happening for all exports or only some? All entities? All views?

Have you tested on different browsers?

I have seen this error caused by the columns in the view. If there is an invalid column, then it will not allow you to export. In my experience this has been due to two columns with the same name. Can you try exporting a smaller subset of columns?