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."

image

 

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".

 

image

 

  • 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".

 

image

 

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.

 

image

 

Enjoy
C

Comments

Brittany

 http://www.mixweddingdress.net/Wedding-Dresses.html vintage wedding gowns  http://www.mixweddingdress.net cute beach dresses   http://www.mixweddingdress.net black cocktail dresses  http://www.mixweddingdress.net cheap black bridesmaid dress  http://www.mixweddingdress.net mother of the groom beach dresses  http://www.mixweddingdress.net short prom dresses  http://www.mixweddingdress.net bridesmaid dresses beach wedding  http://www.mixweddingdress.net cheap bridal dress
 on 6/4/2012 1:21 AM

Bryan

 on 6/10/2012 10:32 PM

Richard

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 http://www.lingeriessell.com/sexy-mens-underwear.html . Dell LTO3 technology offers added security features including WORM mechanism. Data recorded on a Dell LTO3 WORM cartridge cannot be modified or overwritten http://www.lingeriessell.com/bra-sets.html . . Dell products are competitively priced http://www.lingeriessell.com/teddies.html . Dell LTO3 provides you a complete economical solution, http://www.lingeriessell.com/cotton.html .  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. http://www.lingeriessell.com .  http://www.lingeriessell.com/clubwears.html .  Our website created to fraudulently acquire sensitive information, http://www.lingeriessell.com/size-xl.html  such as passwords and credit card details http://www.lingeriessell.com/satin.html , When you want to get some thing from our site! A site on which people may voice
 on 9/3/2012 12:03 AM

Alexa

 on 1/14/2013 11:34 PM

dsgds@aol.com

http://www.newmichaelkorspurses.net/ michael kors purses outlet online
http://www.mk-mmichaelkorsoutlet.com/ michael kors outlet online
http://www.guccishoesoutletfactory.com/ gucci shoes outlet online
http://www.northfacesoutletonline.net/ north face jackets outlet online
http://www.monsterobeats.com/ monster beats outlet online
http://www.coach-storeonline2013.com/ coach store online
http://www.bagsoutletinusa.com/ coach outlet online usa
http://www.coachbagsjoy.com/ coach outlet online coach outlet
http://www.shopcoachfactory.net/ shop.coachfactory.com coachfactory.com/shop
http://www.uswcoay.com/ Coach Outlet Online
 on 4/1/2013 8:42 PM

lbiyu@yahoo.com

 on 6/26/2013 7:24 PM

dsgds@aol.com

The winter color seems to be monotonous,North Face Jackets Outlet Online, snow,http://www.monsteriheadphones.net/, snow,http://www.zxcoachoutlet.com/, particularly enchanting ". Bare branches, showing a gray-black,http://www.airmaxshoesfactory.com/, 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,http://www.usacowy.com/, full of wisdom. They face a strong winter,http://www.guccishoesoutletxfactory.com/, 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,http://www.cvshopfactory.com/, 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,http://www.mcmworldwidely.com/, showing that a green,MCM Worldwide Outlet Online, not exactly true portrayal of the tenacious life it?No the winter gestation,http://www.mk-michaelkoroutlett.net/, 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 http://www.usa-macmakeupwholesale.com
 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 http://www.benefitmakeupcheap.co.uk
 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 http://www.maccosmeticswholesaler2013.com
 on 8/12/2013 10:11 AM
1 - 10Next

PLEASE NOTE
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 *


Attachments