When exporting a query, you might notice that the Excel file has fewer results than the query. The maximum number of records in an export by default is 100,000. However, this value can be set in the web.config file.
To change the maximum results that a query yields:
Open the web.config files on the CRM web servers.
Find the <appsettings> section of the file
Add the following line and save the web.config file: