SharePoint list sometimes does not display items, you will receiver error message as: This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by Administrator.
Also you can check out my previous posts on:
By default lookup threshold is set to 8 in a web application.
To resolve this issue, we need to change the value in the Central Administration. Follow below steps:
Open SharePoint 2010 Central Administration, Then click on "Manage web applications" under Application Management Section.
Then Select the particular web application for which you want to change, And then from the Ribbon Select -> General Settings and Resource Throttling. Check the fig below:
This will open the Resource Throttling dialog box, there navigate to "List View Lookup Threshold" option and change to the proper value according to the requirement. By default the value would be 8.
Remember the maximum number you can set is between 1 to 1000. check fig below:
After this hope the error will not come.