TransWikia.com

Unable to export more than 2000 records to excel from SharePoint external list

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.

2 Answers

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP