I have found and deployed a nice .wsp package that allow you to select items in a sharepoint list or filter a list and it will only export the selected/filtered items. The catch is, you have to select all the items before you click on the 'export' button. If I filter the list and it returns more than 100 items, I can not select the whole list to export - SharePoint has a limit that you can only select up to a 100 items in a list. Is there a way to overcome this?

  • In the view setting (Modified View), you can limit of displayed list items (Number of items to display). – Fox Jun 14 '19 at 7:46
  • Thank you Fox, but the client needs to export all filtered items, even if it is more than 100. For the Export to Excel wsp to work, you have to select all items, and if it more than 100, you can not select them. – Hes JvR Jun 14 '19 at 8:00
  • Nonsense....:() – Fox Jun 14 '19 at 8:42
  • Fox, I think you might misunderstand me. For example, the client wants to export all items created since January to March in 2018. Which can be 198 items. For this custom .wsp export function to work, you need to select the items in your list that you want to export, but Sharepoint does not allow you to select more than 100 items. Therefor, the client can not select all 198 filtered items to export with the custom export to excel function. (I know when you have a list and you use the built-in SharePoint export to excel function, it will export all.) – Hes JvR Jun 16 '19 at 18:10

Why not just create a filtered view of the list then export that view to Excel, this is OOTB functionality.

| improve this answer | |
  • Thank you evilfoamy, but the client want to use different criteria for each export to excel. A filtered view is fixed on the criteria you set it up with – Hes JvR Jun 16 '19 at 18:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.