Skip Ribbon Commands
Skip to main content

Quick Launch


 Important Posts

 Complete MOSS Licensing Info
 SharePoint Speak Terminology Dictionary
 SPCAP - SharePoint Capacity Planning Tool
 Step-by-Step – A REAL world upgrade of a SharePoint Portal Server 2003 (SPS) farm to Microsoft Office SharePoint Server 2007 (MOSS)
 Best Practice - Determine if a SPUser has Admin rights to the SPWeb
 SharePoint 2010 - Good, Better, Best
Cornelius J. van Dyk's SharePoint Brain Dump > Posts > How do I solve - This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold enforced by the administrator?
November 07
How do I solve - This view cannot be displayed because the number of lookup and workflow status columns it contains exceeds the threshold enforced by the administrator?

If you've ever migrated site collections from one farm to another, or upgraded from a 2007 farm to a 2010 farm, you may encounter this error the following 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."



This is caused by Resource Throttling that was introduced in SharePoint 2010.  The settings can easily be adjusted to cater to your specific environment and are set for each web application.  To adjust the limits, follow these steps:

  • Open Central Administration
  • Click "Application Management" in the left navigation menu.
  • Click "Manage Web Applications" on the Application Management page.
  • A list of all your web applications in the target farm will be displayed.  Select the target web application by clicking the white space between the Title and the URL.
  • The Ribbon should now light up.  Click on "General Settings".  Do NOT click the gears icon above General Settings as it will take you to the General Settings page instead of the Resource Throttling page.
  • A dropdown menu will activate.  On this menu, click "Resource Throttling".




  • On the Resource Throttling page, scroll down to the List View Lookup Threshold section.  By default, this value is set to 8.
  • Change the value to the desired number.
  • Scroll down and click "OK".




Now when you navigate back to the list view in question, provided the lookups is less than the number you just set, the view should render normally.






Brittany vintage wedding gowns cute beach dresses black cocktail dresses cheap black bridesmaid dress mother of the groom beach dresses short prom dresses bridesmaid dresses beach wedding cheap bridal dress
 on 6/4/2012 1:21 AM


 on 6/10/2012 10:32 PM


that will lead to lower total ownership cost. Outstanding media compatibly offered by this devices provide customers more flexibility in vendors and allows troublefree migration path . Dell LTO3 technology offers added security features including WORM mechanism. Data recorded on a Dell LTO3 WORM cartridge cannot be modified or overwritten . . Dell products are competitively priced . Dell LTO3 provides you a complete economical solution, .  which assures seamless and effective business operations. All names of devices and products mentioned in the articles are trademarks and are sole property of their respective owners. . .  Our website created to fraudulently acquire sensitive information,  such as passwords and credit card details , When you want to get some thing from our site! A site on which people may voice
 on 9/3/2012 12:03 AM


 on 1/14/2013 11:34 PM michael kors purses outlet online michael kors outlet online gucci shoes outlet online north face jackets outlet online monster beats outlet online coach store online coach outlet online usa coach outlet online coach outlet Coach Outlet Online
 on 4/1/2013 8:42 PM

 on 6/26/2013 7:24 PM

The winter color seems to be monotonous,North Face Jackets Outlet Online, snow,, snow,, particularly enchanting ". Bare branches, showing a gray-black,, it seems a bit of life. In fact,Michael Kors USA, life is still writing a moving chapter,Coach Factory Outlet Online, the branches of the tooth bud is the best interpretation. At this time of life is tenacious,, full of wisdom. They face a strong winter,, just to avoid the edge,Louis Vuitton Factory Outlet, to retreat,Gucci Shoes Factory, the power savings,Coach Outlet Online, only to be one day,Nike Air Max Shoes, a comeback toward a stage of history,Coach Outlet, staged a wonderful life.In the depth of winter,, the bright eyes of the good gaze was still able to capture to that Aoxue the Plum blossom branches,Monster Headphones Outlet Online, showing the tenacity of life; struggle with winter wheat seedling fields,, showing that a green,MCM Worldwide Outlet Online, not exactly true portrayal of the tenacious life it?No the winter gestation,, there is no show strong spring to life.
 on 7/18/2013 7:10 PM

Mac Makeup Wholesale

This specific makeup is actually definitely good, it has countless capabilities and functions. Mac Makeup Wholesale
 on 8/12/2013 10:11 AM

Benefit Makeup Sale

makeup was a little too simple previously, but these days it is close to impossible Benefit Makeup Sale
 on 8/12/2013 10:11 AM

cheap mac makeup

To Those Who Wants To become skilled at makeup But Finding it difficult to Get Rolling cheap mac makeup
 on 8/12/2013 10:11 AM
1 - 10Next

Comments are moderated so posting your comment here, will NOT make it visible right away.  Once I've reviewed your comment, I will publish it for all to see.  This is unfortunately needed in order to deal with all the crapware and spambots that post to my blog on a regular basis.

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.

Your Email or Blog URL *

Body *