How to increase lookup column limit in SharePoint lists

Lookup columns include workflow status columns, traditional lookup columns to other lists, and person/group columns. This includes the two default people fields “Created by” and “Modified by”. If your list has more than 12 of these, you may receive the following error:

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

list view threshold.PNGIn SharePoint Online, you’re not able to increase the lookup column limit. Lists created prior to the June 2013 CU update are capped at 8 lookup columns, while those afterward are allowed 12.

However, on-premise SharePoint (server) allows you to change this limit to your heart’s content.

  1. Go to Central Admin
  2. Click manage web apps
    manage web applications
  3. Select the web app for which you’re increasing the lookup limit
    select site
  4. Click the drop-down arrow beneath “General Settings” –> “Resource Throttling”
    resource throttling
  5. Change the list view lookup limit and save
    lookup limit
Advertisements

Written by SharePoint Librarian

I'm a SharePoint Business Analyst and Jayhawk from the Kansas City Area.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.