I have an Excel sheet with 200K rows and I want to replace it with a SharePoint 2016 list, since Excel files in SP don't allow for simultaneous editing by multiple users. Ideally I would create a custom form for a user to look up an entry by ID, as well as content queries that show the most recent entries. Although SP lists are capable of millions of rows, will server performance be affected with what I'm proposing?
2
-
SharePoint on-premises does support co-authoring for Excel files, assuming everyone is using the Excel web app: docs.microsoft.com/SharePoint/governance/…– Callum CrowleyCommented Mar 29, 2022 at 16:22
-
Thanks. To my knowledge, all the users have the Excel client application instead of the web app.– carston1998Commented Mar 29, 2022 at 16:41
Add a comment
|
1 Answer
In SharePoint 2016, you can store about ~30,000,000 items per list, However, you should think about the List view threshold that was increased in SharePoint 2016 to be greater than 5,000 items.
Read more about SharePoint 2016 List and Library Limits
Regarding the List view threshold, you will get this error in case, the list items become more than 5000 items
Microsoft put a threshold or a limit to not retrieve more than 5000 items or files at a time in a single view
However, you can overcome this limitation by following the instruction mentioned in this article Manage large lists and libraries
You may also like to read SharePoint 2019 Limitations
answered Mar 29, 2022 at 16:56
-
Does the list view threshold apply to queries as well, where the user is looking for a single item? Commented Mar 29, 2022 at 18:23
-
The list view threshold will be applied In case, the retrieved items are more than 5000 items! Commented Mar 29, 2022 at 20:05