I am unable to export more than 2000 records to excel from SharePoint external list. I am able to see 5000 records in external list but only 2000 records getting exported to excel.
Any help on this would be highly appreciated.
Thanks in advance.
Extracted data in excel spreadsheets matters with how you setup your sharepoint list view. If you are extracting data from a listview with filtered items, it will only get the data that the listview is supposed to get.
I suggest, you extract your data from a listview that doesn't have any filters on, 'All Items'.
Hope it helps! Happy SharePointing!
Answered by Edwin on January 6, 2022
Since you can see 5000 items, I would assume you already set the throttling with
Set-SPBusinessDataCatalogThrottleConfig. So you're now good from the server side. Now the limitation comes from MS Office. You can change that by adding a new dword
Query Instances Limit in
[HKEY_CURRENT_USERSoftwareMicrosoftOfficeVERSIONCommonBusiness DataSynchronization] on the client machine. Set the value to 5000.
Answered by Paul Strupeikis on January 6, 2022
1 Asked on January 8, 2021 by user876869
2 Asked on January 8, 2021 by user3080110
1 Asked on January 8, 2021 by garima
2 Asked on January 8, 2021
1 Asked on January 7, 2021 by gwenguts
2 Asked on January 7, 2021 by elina
0 Asked on January 6, 2021 by pradeep
1 Asked on January 4, 2021 by cory
3 Asked on January 4, 2021 by kumarv
1 Asked on January 3, 2021 by jason-sandholm
0 Asked on January 3, 2021 by nidhi-maheshwari
1 Asked on January 2, 2021 by john-john
0 Asked on January 2, 2021 by g-srinivas
1 Asked on January 1, 2021 by users1100
1 Asked on January 1, 2021 by sasfrog
1 Asked on January 1, 2021 by r_lothbrok
1 Asked on December 30, 2020
1 Asked on December 30, 2020 by noai
1 Asked on December 29, 2020 by piero
Get help from others!