locked
Excel Export limited to 10,000 records un Dynamics CRM 2011 RRS feed

  • Question

  • I am using Dynamcs CRM 2011 and when I export to Excel it only export 10,000 records,

    Any suggestion how to get the full Contact Information?

    Best Regards

    Wednesday, March 28, 2012 5:42 PM

Answers

  • You could try saving the export as a dynamic worksheet and then on the Data tab in Excel select Connections -> Connection -> Properties -> Definition tab -> and under Command text remove the text "top 10000". 

    OK and save everything and then hit Refresh from CRM and see if it brings back all the records.


    Jason Lattimer

    Wednesday, March 28, 2012 6:04 PM
    Moderator

All replies

  • You could try saving the export as a dynamic worksheet and then on the Data tab in Excel select Connections -> Connection -> Properties -> Definition tab -> and under Command text remove the text "top 10000". 

    OK and save everything and then hit Refresh from CRM and see if it brings back all the records.


    Jason Lattimer

    Wednesday, March 28, 2012 6:04 PM
    Moderator
  • Jason,

    Excellent recomendation, it works just fine

    Best Regards

    Thursday, March 29, 2012 12:55 AM