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

I have the same question (0)

All responses (6)

Answers (2)

KylieKiser 2,174 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
dmitrii pivovarov 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Gampi Reddy 87 on at

Like (0)

Report

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.

Was this reply helpful? Yes No