SharePoint list error- Crow Canyon Software

SharePoint list error

Question / Issue

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


 

Answer / Solution

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.

Solution:
Adjust setting for the list throttle

  • Open the SharePoint Central Administration,
  • Go to Application Management –> Manage Web Applications
  • Click to select the web application that hosts your list (eg. SharePoint – 80)
  • In the Ribbon, select General Settings/Resource Throttling
  • In the List View Lookup Threshold limit, edit the value you want (for example, 16 instead of the default 8).
  • Click OK to save it.