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
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