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

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

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

Solution: Add some filters to get the data, so that it will work.

Or Create new view with some filters then give the source as new view.

Or Delete some of the records from list view if there are any unused data, then it will work.

Or Add Filter on top of your existing query...

EX:

MyQuery = "<Query>"
+"<Where><And><Gt><FieldRef Name=\"ID\" /><Value Type=\"Counter\">0</Value></Gt>"
+ Query
+"</And></Where>"
+"<OrderBy>"
+"<FieldRef Name='ID' Ascending='False' />"
+"</OrderBy>"
+"</Query>";

How this one will work is: Every List will be indexed with Default Column that is : ID

So when you add <Gt><FieldRef Name=\"ID\" /><Value Type=\"Counter\">0</Value></Gt> this will get the data from SQL with indexed way, so there won't be any time delay....Now u will not get : view threshold error.

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

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

We have to change some setting in CA (Central Admin)

By default ‘List View Threshold’ is set to 5000, you need to change the setting if you need to show more than 5000 items. Please ask your administrator to increase the ‘List View Threshold’ value. Steps to reset the value :

Open Central Administration
Go to ‘Manage Application’ under ‘Application Management’
Choose the web application in which you want to make the changes (example :http://SP2010:80)
In the ribbon follow ‘General Settings -> Resource Throttling’ there you can find ‘List View Threshold’ is set to 5000, change the value you want

Note: it is not recommended to change the default threshold limit