Skip ahead to the main page
Partner Huddle
Pages

SharePoint limits: 5 checks for client libraries

Partner Huddle Editorial Team · Published · 11 min read

Check five SharePoint limits for client document libraries: read-only recovery, purchase confirmation, file paths, item counts and permissions inheritance.

Key takeaways

  • Read-only mode: name who can approve storage changes and purchases before you need them.
  • Confirm purchase: record each use and the completed purchase.
  • File paths: test your longest real decoded file path.
  • Item counts: count both files and folders in each library.
  • Permissions: check the item count before you break inheritance.

If your firm keeps those documents in SharePoint or OneDrive, the service limits set by Microsoft affect how you set up and run each client library. The reference page for this topic is SharePoint limits, which covers the service limits in SharePoint for Microsoft 365.

This post covers five of those limits that bear most directly on how you set up client libraries. None of them is a reason to avoid SharePoint. They are numbers to check on purpose, before a library grows large and before a deadline depends on it.

This post is about SharePoint and OneDrive in Microsoft 365. It does not cover other storage products, which have their own rules and limits, so check their own documentation if your firm uses them.

What restores editing if your tenant is in read-only mode?

Microsoft says that if your tenant is placed in read-only mode, you can restore editing by reducing storage usage, purchasing additional SharePoint storage, or purchasing eligible licenses ( SharePoint limits).

Read-only mode is worth checking first, because it is the state in which editing is not available until someone restores it. A firm in the middle of a filing deadline needs to know in advance how editing comes back, not discover it on the day.

Microsoft's wording gives three routes, and they are not equal in effort. Reducing storage usage means someone has to decide what content can go, which is a judgment call rather than a quick fix. Buying more SharePoint storage or eligible licenses is a purchase, so the decision belongs to whoever approves spending.

Before you need any of these routes, write down who can approve a purchase in your Microsoft 365 account and who can make changes to storage. Keep that note with your other IT details. If the tenant goes read-only during a busy period, you should not be searching for the right person while clients wait.

A practical first step is to name one person who owns the Microsoft 365 account for the firm. That person should know who to call if the tenant is placed in read-only mode, and who else needs to hear about it. If an outside IT provider supports your firm, put the answer in writing, so nobody has to guess on a busy day.

Next, look at how your firm uses storage today. List the largest libraries, the ones holding years of client files, and note which ones grow fastest during the year. You do not need precise figures to start. A rough list shows which libraries deserve attention first.

When read-only mode affects a live filing, keep communication simple. Tell the people who need to know what is blocked, what the firm is doing about it, and when the next update will come. A short message to the team is better than a rushed change to files that nobody has reviewed.

Avoid workarounds in a hurry. Copying files to a personal drive or email to keep working can create a second set of records that nobody tracks. If the firm needs to keep working, agree on a temporary plan with the partners first.

Keep a record of when the tenant was placed in read-only mode, which step restored editing, and how long it took. Set a regular reminder to look at storage use, perhaps at the start of each month, and before any season that brings heavy uploads. A reminder costs little and gives the firm time to act before the team feels a block.

When can you use Confirm purchase, and for how long?

Microsoft says that if you've completed a purchase and Confirm purchase is available, you can select it to temporarily remove read-only mode for up to 14 days while the new capacity is applied ( SharePoint limits).

That gives you a bridge, not a permanent fix. The same page says Confirm purchase can be used only once in a 365-day period.

Do the urgent saves first, and do not assume you have the full two weeks.

Keep a note of each purchase and the date you used Confirm purchase. Use that note to check whether you have already used the option within the current period.

Before you select the option, make sure the team knows what the temporary editing window is for. Use the time to reduce storage usage, review which libraries are largest, and confirm who will handle the next purchase.

Plan the purchase around a known date. If a purchase would make sense before a major deadline, buy early enough that the confirmation step is not the last thing you do before a client call. Keep a copy of the purchase details and the date, so you can answer questions from partners later.

Decide who is allowed to confirm a purchase. Confirm purchase is a step in the account, so it helps to name one approver and one backup, and write both names next to the purchase record.

What is the file path limit for OneDrive and SharePoint?

Microsoft says the entire decoded file path, including the file name, can't contain more than 400 characters for OneDrive, OneDrive for work or school and SharePoint in Microsoft 365 ( SharePoint limits).

A client structure with a client name, a tax year, a form group and a document title is easy to build, and each layer adds characters.

Test the limit on a real file, not a sample. Take the longest document in a recent client folder and count every character in its entire decoded file path, including the file name. If the count is close to 400, shorten the folder names before the library is full of files. Short, stable folder names, such as a client number in place of a long legal name, leave more room for the document title.

If a file already has a path that is too long, shorten the folder names first, since they appear in every file path below them, and then check the full path again.

Naming rules work best when the whole firm uses them. Pick one order for folder names, such as client number, then year, then document type, and apply it everywhere. A consistent order makes it easier for staff to find files and easier to check the path length, because everyone builds paths the same way. Include the naming guide in your client intake handoff checklist.

Look for names that repeat at several levels. If the client's full name appears in the library, the folder and the file title, each copy adds characters. A client number in the folder path with a short name in the file title may leave more room.

Check paths again when you move files. A move can change the full path, and a file that was under the limit can end up over it after it lands in a deeper folder.

Write a short naming guide and keep it with the other firm documents. One page is enough. It should list the folder order, the length you aim for, and the person who approves changes.

How many files and folders can a library hold?

A library can have up to 30 million files and folders, and a list can have up to 30 million items, according to Microsoft ( SharePoint limits).

That is a ceiling for each library, not a target. The more useful check is how your firm divides its files. A firm that keeps every client in one library has one count to watch. A firm that splits by client, tax year or service line spreads files across several libraries, and each library has its own count to watch.

The library limit counts folders as well as files, so a deep set of subfolders adds to the count even when each folder holds only a few documents.

Estimating growth is the practical part of this check. Count both files and folders in one client folder for last year, then multiply by the number of active clients to get a rough figure for the library. Do the same for lists that track intake, tasks or deadlines.

Then compare the rough figure with the library ceiling and write both numbers down. The next person who manages the library should be able to see where it stands against that limit.

Illustrative example: counting library items

An illustrative client folder contains 30 files and 70 subfolders. Together, they contribute 100 items to the library count. Counting only files would miss the subfolders. Use the combined count when estimating growth, and check the library's actual total before making a decision.

One option is a library for each tax year, with older years moved into an archive library once they are closed. Each library then keeps its own count, and the current year is easier to manage.

Lists need the same care as libraries. A list that tracks client intake, tasks or deadlines can grow with every new client, so review its count at the same time as the libraries. If a list nears its limit, consider splitting the work into separate lists by year or by service line.

What happens to permissions above 100,000 items?

Microsoft says that when a list, library, or folder contains more than 100,000 items, you can't break permissions inheritance on the list, library, or folder ( SharePoint limits).

Breaking inheritance lets a folder have its own access list instead of following the library above it. If you want a client folder visible only to its engagement team, this is the setup the rule affects. Check the item count of that folder before you set its permissions, not after.

The point is timing. Set client-only access on a new folder while it is small, and review the count at the start of each year.

Test access before you rely on it. Ask a team member who should not see the folder to confirm they cannot open it. Then ask one who should see it to confirm they can.

Record the change in your notes. Write down the folder, the date inheritance was broken, and who now has access. Without that record, a later reviewer may not know why a folder behaves differently from the library around it.

Keep the default for each library as the baseline, and treat each broken inheritance as an exception that needs a written reason.

When you decide who gets access to a client folder, start with the engagement team and the partner responsible for that client. Add anyone else only when they need the files for their work. Keep the list short, because each name is one more person to review when staff change roles. Review the list each time staff join or leave the firm, and record the reason for each person's access. Use the client data access controls guide alongside that review.

Think about the partner's view as well. A partner who must sign off on client access may want a short explanation of each exception, and a written reason makes that conversation quicker.

What mistakes should you avoid?

The main mistake is to treat these limits as a problem for later. The read-only mode and permission limits are easier to plan around when the library is new, and the path limit is easier to meet when names are set before the first file is saved.

Another mistake is assuming the firm's storage will stay the same. Client files accumulate, and a library that feels comfortable today can grow toward the limits you planned around.

A third mistake is copying a folder structure from one client to the next without checking the path. A structure that works for a short client name may go over the limit with a long one, and the file title adds characters on top.

The fourth mistake is breaking inheritance on a folder without checking its count, or treating permissions as something to fix later. A folder's access list is easiest to set when the folder is created; check its count again before any later attempt to break inheritance.

The last mistake is treating these five checks as a one-time task. Storage, file paths and item counts change as your client base changes, so the checks belong on a calendar, not in a single afternoon's to-do list.

What should you do first?

Start with the file path check today, because it needs only one real file and a written count. Then write down the storage and purchase contacts for read-only mode, and list your largest libraries and lists for the item count. Last, decide which folders need their own access lists, and check each one's count before you break inheritance.

Once those notes exist, share them with the partners, and set a date to revisit them before the next busy season.

When should you run these five checks?

Run them before you create a client library, and again as the library grows. Use this list as a starting point, and keep the Microsoft page open while you work through it.

Ask each person to report any read-only status, path problem or access problem the day it happens, so the notes stay current.

Where should you check the current limits?

Compare your notes with the current SharePoint limits page before you rely on any number here. Microsoft may change its service descriptions. If a number in this post no longer matches the page, the page wins. Update your notes, and tell the partners what changed and when.

Who decides access and record retention?

Your firm decides who should see a client file and how long to keep records. A short review at the start of each busy season gives you time to act before a limit gets in the way of client work.

Sources