1

I am facing following warning message when i add list as webpart. "This view cannot be displayed because it exceeds the list view threshold (5000 items) enforced by the administrator."

Also when i directly go to the list and change the view it gives "Displaying only the newest results below. To view all results, narrow your query by adding a filter".

Any suggestions/pointers on this would be higly appreciated.

Regards, Ketan Gandhi

Improve this question

2 Answers 2

Reset to default
3

Hi by default 'List View Threshold' is set to 5000, you need to change the setting if you need to show more than 5000 items. Please ask your administrator to increase the 'List View Threshold' value. Steps to reset the value :

  1. Open Central Administration
  2. Go to 'Manage Application' under 'Application Management'
  3. Choose the web application in which you want to make the changes (example : http:// yourserver:80)
  4. In the ribbon follow 'General Settings -> Resource Throttling' there you can find 'List View Threshold' is set to 5000, change the value you want
Improve this answer
4
  • 1
    @Diptarag...many thanks for your response, however it is not recommended to change the default threshold limit...Also my list contains more than 5000 item, however my "View" does not contain more than 5000 items. Also in case of second error" Displaying" it sometimes work for few views with this warning message and in few views it does not disply any items
    – Ketan03
    Commented Aug 13, 2012 at 9:18
  • yes that's a cmmon problem as ur view is nothing bt a query and that threshold applies to query also,evn if ur view return less than 5000 rows but ur query runs on a list which has more than 5000 items,you may try indexing the field on which you are creating the view,this may avoid the problem or you can temporarily disable the threshold,for more detail please visit these links [link]sharepoint.microsoft.com/blog/Pages/… & [link]sharepoint.microsoft.com/Blogs/GetThePoint/Lists/Posts/…
    – Diptarag
    Commented Aug 13, 2012 at 9:49
  • @Diptarag..... i guess "Indexed Column" should hopefully resolve this issue?
    – Ketan03
    Commented Aug 13, 2012 at 10:34
  • @Ketan03 I think so, please try once and do let us know if it works
    – Diptarag
    Commented Aug 13, 2012 at 12:40
0

Not Recommended. Create indexed column and create filter views of list.

Improve this answer
1
  • Hi Shilabhadra, Welcome to SP.SE! While your answer is on the right track, it could be marked for deletion as it's very short and lacks details. Can you please edit your answer to elaborate the points points?
    – Vardhaman Deshpande
    Commented Nov 11, 2013 at 11:37

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.