Calendar View Always shows List threshold exceeded error

Question

I am using Sharepoint 356 (office 365). I recently migrated my site from sharepoint 2007 to 365.

I used to have a calendar on my homepage that had 5800 items. Office 365 view limit is 5000. So the calendar view does not show any items. It just shows this error message

This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator.

To view items, try selecting another view or creating a new view. If you do not have sufficient permissions to create views for this list, ask your administrator to modify the view so that it conforms to the list view threshold.

I have clicked on "Modify View" and then set Created as [Today]-5 which should lead to 5-10 entries. Yet on the homepage where the calendar should show the error continues to be displayed.

Why is this not taking effect?

NOTE: that i am not using Team Site. Still using the old UI of sharepoint. If i click on the View Name the next page successfully shows the items.

Answer 1

Changing the view is not sufficient, you also have to add an index to the list. List settings -> create an index

Answer 2

Clarification questions... (too many characters for a comment)

1. Can you toggle to another view without getting the error?
2. For list indexing, try creating additional indices (event name, start date, category, etc).
3. For Page Editing: Can you navigate to a separate page and go into edit mode? I'm assuming this is a publishing site collection. If not, try navigating to the culprit page via Site Contents/Pages or Site Pages, select the ellipses and check the page properties, permissions. SP Online has recently enabled a timeout function so if you're using a stale browser instance, the page may show as checked out to you, while not letting you edit. If/when you see that, do a force refresh.

As a fallback option:

Lists created in O365 can have up to 20 million items with defined views and indexing applied. I'm not sure what the success stories are for migrated lists vs imported into new lists. Your list is behaving like a remnant.

You probably still have migration tools handy. An option to consider is to create a new calendar in the new environment, then migrate the data from your old calendar over. Sharegate or something like it are great, especially if you already have defined content types or metadata.

I've had to do this with a few lists post-migration for various reasons, and it's not as painful as it sounds (if you have the tools for the job).

Good luck -

Answer 3

You need to modify the view the calendar webpart is using.

• Edit the page

• Put the webpart in edit mode

• Modify the view and apply the filter

• Save the page