Error Message:

SharePoint list error: lookup and workflow status columns exceed the threshold.

Problem Description:

Users get this error when accessing a SharePoint list:

This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.

Resolution:

Follow below steps:

1.    Open the SharePoint Central Administration

2.    Application Management

3.    Manage Web Application

4.    Select Your Web Application

5.    General Settings

6.    Resource Throttling

7.    By default List View Lookup Threshold is 8 change it as per your requirement and

8.    Finally click OK to save it.

Feel free to revert in-case of any query...

Product Applies To:

·         SharePoint Server 2010

·         SharePoint Foundation 2010

·         SharePoint Server 2013