4

Hi I'm new to using SharePoint. I am looking to create a master excel which will feed into over 200 small excels sheets, all held on SharePoint. The smaller excels will be 'read only' and each password protected. Max amount of rows held in the master excel would be 7,000. My question is:

  1. What is the limit of users that one site can have? Could be 300+ users
  2. Is there a limit to the number of excel sheets I can upload? estimated 200+
  3. Are there any other issues that may arise from using SharePoint like this?

Any help would be great! Thanks

5
  1. You can add up to 2 millions users in single site collection. MSDN Source

  2. You can add up to 30,000,000 documents per document library MSDN Source

  3. The maximum size of a workbook that can be opened in Excel Services is 10 MB. MSDN Source
  4. You can manage up to 400,000 versions of items/files in list/library.

For more limits and boundaries of SharePoint

2

I couldn't comment on Vishal's answer so I will have to write my own.

  • The users limit is 2 million in a single site collection.
  • As previously mentioned you can add up to 30,000,000 documents per document library or 30,000,000 items per list.
  • Again, as previously answered by Vilash you can also manage 400,000 versions.

It is worth noting though that these are out of the box limits and they can be altered by your SharePoint site admins to reduce load on servers. It may be worth consulting your SharePoint admins on the limits specific to your companies instance of SharePoint.

extra: When using Excel in SharePoint it can sometimes be an option to use a list to house the excel data, however this would not be appropriate in your case as the list view threshold limit is 5,000 items. After 5,000 items the list locks up when loading the data for all users and then begins to cause issues with service disruption. As long as you limit the number of items within your list view to less than 5,000 items, you will not run into any issues. The threshold limit can be increased, but is not recommended.

Hope this helps and apologies I could not just simply comment on Vilash's answer!

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.