You will get the below error sometimes while working with SharePoint 2010 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.".
Actually rather you will say this as an error betther we can say this is a setting provided by SharePoint to improve performance issue. This is related to List throttling which is introduced in SharePoint 2010.
The default value is 8 and that can be increased. To increase this
Open SharePoint Central Administration.
Click on Manage web application from Application Management section.
This will open the list of all web application and from there select the web application and click on General Settings from the ribbon and then select Resource Throttling as showing in the figure below.
Then this will open the Resource Throttling dialog box. Navigate to List View Lookup Threshold and change the value from default 8 to more than that as shown in the figure below.
Then it should work now.
"This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold (8) enforced by the administrator.".
Actually rather you will say this as an error betther we can say this is a setting provided by SharePoint to improve performance issue. This is related to List throttling which is introduced in SharePoint 2010.
The default value is 8 and that can be increased. To increase this
Open SharePoint Central Administration.
This will open the list of all web application and from there select the web application and click on General Settings from the ribbon and then select Resource Throttling as showing in the figure below.
Hello, my name is Bijay. I'm a SharePoint MVP. 