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!

Related Questions

Like the List created and not the list item

2  Asked on January 27, 2021 by antra-sharma


SP 2016 – Only TTFB slow

2  Asked on January 16, 2021 by mhouston100


Unable to upload to SharePoint Online via VBA

1  Asked on January 11, 2021 by leroy


How to Create WF with C#

2  Asked on January 8, 2021 by whatsup


Ask a Question

Get help from others!

© 2022 All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP