The attempted operation is prohibited because it exceeds the list view threshold

Ray Waldron 46 Reputation points
2023-05-10T13:40:36.6666667+00:00

Hiya ,

We have users that connect to a sharepoint online calendar from their outlook desktop.

Recently with new employees , when you try to connect to the calendar in outlook for the first time you get the error.

"The attempted operation is prohibited because it exceeds the list view threshold"

Now the calendar does indeed have slightly more entries that 5000, however, users on windows 10 do not have this error and a user on windows 11 does not have this error. We get the error for new employees on windows 11. I have seen some forums mentioning having to keep the entries below 5000, surely there is a way to continue past this threshold ?

The fact that we have a windows 11 user we no issue gives me hope that there is a fix. I just don't know why it's ok for that user? any help please.

similar question to below , except we are NOT using on premise so we can't increase the threshold.

https://learn.microsoft.com/en-us/answers/questions/498269/sharepoint-2019-on-premise-problem-with-sp-calenda

R.

Outlook | Windows | Classic Outlook for Windows | For business
Microsoft 365 and Office | SharePoint | Development
Microsoft 365 and Office | SharePoint | For business | Windows
Microsoft 365 and Office | SharePoint Server | Development
{count} vote

1 answer

Sort by: Most helpful
  1. Xyza Xue_MSFT 30,176 Reputation points Microsoft External Staff
    2023-05-11T06:48:30.7733333+00:00

    Hi @Ray Waldron ,

    Are you using Sharepoint Online? We can’t change the list view threshold in SharePoint Online. The number 5000 is fixed and controlled by Microsoft to ensure better performance in SharePoint Online, as it operates as a shared tenant environment. So, increasing the list view threshold is not possible. This is by default. If it’s SharePoint On-premises, You can change the list threshold via the Central Administration site: How to Increase List Threshold in SharePoint Server?

    You can store up to 30 million items or files in a list or library. However, when a list view shows more than 5000 items, you may run into a list view threshold error. This is uncontrollable and uncertain.

    User's image

    Reference: https://support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59#:~:text=on%20the%20ribbon%2C%20on%20General,Select%20OK.

    I can't reproduce your problem. If you think it affects your work, I suggest you make a services request in the M365 admin center.

    User's image


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.