Answered by:
Export to Excel only brings back maximum 10000 records???

Question
-
we have got over 50k accounts and we want to export this to excel so that we can pass this data to other system but when we click on export data to excel and then select second option (static worksheet with records from all pages), it still export only first 10,000 records..
we have also tries other option dynamic worksheet but again it comes back with only first 10k records..
we have tried doing report but again while exporting to excel or csv, it times out becuase of the number of account records..
Is there any way we can chnage this setting so that more than 10k records are exported to excel by default...Tuesday, September 8, 2009 8:34 AM
Answers
-
Hi,
look at this article
http://blogs.inetium.com/blogs/microsoftcrm/archive/2008/06/18/exporting-more-than-10-000-records-to-excel-in-crm-3-0-4-0.aspx
Viele Grüße
Michael Sulz
axcentro GmbH
MVP für Microsoft Dynamics CRM- Marked as answer by Mayank Pujara Tuesday, September 8, 2009 8:52 AM
Tuesday, September 8, 2009 8:39 AM -
Thanks Michael!!
I have also found following link for the same..
- Marked as answer by Mayank Pujara Tuesday, September 8, 2009 8:52 AM
Tuesday, September 8, 2009 8:52 AM
All replies
-
Hi,
look at this article
http://blogs.inetium.com/blogs/microsoftcrm/archive/2008/06/18/exporting-more-than-10-000-records-to-excel-in-crm-3-0-4-0.aspx
Viele Grüße
Michael Sulz
axcentro GmbH
MVP für Microsoft Dynamics CRM- Marked as answer by Mayank Pujara Tuesday, September 8, 2009 8:52 AM
Tuesday, September 8, 2009 8:39 AM -
Thanks Michael!!
I have also found following link for the same..
- Marked as answer by Mayank Pujara Tuesday, September 8, 2009 8:52 AM
Tuesday, September 8, 2009 8:52 AM -
The other option, rather than making changes to the database, is to edit the dynamic worksheet query. See here for details:Leon Tribe
Want to hear me talk about all things CRM? Check out my blog
http://leontribe.blogspot.com/or hear me tweet @leontribe
Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe- Proposed as answer by Leon TribeMVP Tuesday, September 8, 2009 8:49 PM
Tuesday, September 8, 2009 8:49 PM