SharePoint 2010 Show items in list WebPart to users when there are more than 5000 items

If a list has more than 5000 items, SharePoint 2010 shows users a 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."


For some reason this limit has been lowered to 5000 by default in SharePoint 2010.

To change this : 

1- Login to Central Admin

2- Go to Application Management -> Manage Web Applications

3- Pick the Web application for which you want to change the List View Threshold.

4- In the ribbon above, click General Settings. This will bring down a menu, from which you should pick Resource Throttling

5- Change the List View Threshold to another value greater than 5000 and press OK, but please try to keep it to a reasonable number below 20,000 is a recommendation.

Refer to here for the original tip http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx