SharePoint Asked on January 6, 2022
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP