Got an error “This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.” while viewing your Sharepoint List or Library, no worries, it’s just a Lookup Threshold that Sharepoint enforces on a Web application by default. To get rid of this problem, do the following:

  1. Go to the Central Administration.
  2. Under Application Management, go to Manage Web Applications.
  3. Select the Web Application, that gives you see this error.
  4. On the Ribbon, look at 4th icon from left that says “General Settings”, click on the arrow at the bottom of the button and select the second option “Resource Throttling”.
  5. In the dialog that opens, scroll down till you see “List View Lookup Threshold”, you would see that by default the value is 8. Increase to a number suitable to your requirements and save it by clicking on OK.
  6. Go again to the list/library that gave the error and it should be working now provided the value that you set as threshold is a more than lookups your list/library requires to do to show the content.