News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Unable to Export Compa...

Customer experience | Sales, Customer Insights,...

Unanswered

Unable to Export Company list to Excel receive (An error has occurred)

(1) Share

Report

Report

Posted on by RW-30051027-0

2

Hello Community,

We currently run Dynamics CRM 4.0 (4.0.7333.3822) and are looking to migrate to a newer version.

We're currently in the process of trying to export a list of our Companies using the /Active Accounts/ View.

When generating the view we are returned with 42025 companies and 10 column's, non of the columns have duplicate names.

We receive an error when trying to export all pages to Excel and the error just states /An error has occurred/

We're able to export select items or a whole page (250 results) but just not all 169 pages.

Any help would be appreciated.

All responses Img

All responses (2)

Answers Img

Answers (0)

RW-30051027-0 2 on at

Like (0)

Report

Unable to Export Company list to Excel receive (An error has occurred)

Hello Leah

Many thanks for your response.

I have just checked and we are able to export more than 10,000 entries in the contact section but just not the company section. I have checked and we have just as many contacts as we do Companies. Is this limitation exclusive to the Company list?
Leah Ju Microsoft Employee on at

Like (0)

Report

Unable to Export Company list to Excel receive (An error has occurred)

Hi,

Based on the documentation:

By default, you can export a maximum of 10,000 records from Microsoft Dynamics CRM to an Excel worksheet by using the Static worksheet with records from all pages in the current view feature.

https://learn.microsoft.com/en-us/previous-versions/troubleshoot/dynamics/crm/how-to-change-the-maximum-number-of-records-that-can-export-from-crm-to-excel

Try to export more records:

https://andrewcampey.wordpress.com/2017/07/26/259/

https://xrmdynamicscrm.wordpress.com/2020/06/11/dynamics-365-quick-tips-export-1-million-record-using-excel-static-sheet/

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

Holly Huffman 103

#2

Muhammad Shahzad Sh... 96 Most Valuable Professional

#3

Gerardo Rentería Ga... 51 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans