Solved

SharePoint throttling limit the view to 5000 records. (Best way to get around)

Posted on 2016-11-02
6
15 Views
Last Modified: 2016-11-21
Hello,

My Company just turned on "Throttling" on our SharePoint 2010 sites and now all Views are limited to 5000 records and if there are more than 8 lookup boxes the list will not link to an Access DB.  

I am looking for the best "Work Arounds" from a user perspective as this is crippling many individuals and there doesn't seem to be any chance of IT undoing this change.
0
Comment
Question by:vmccune
  • 4
  • 2
6 Comments
 
LVL 31

Accepted Solution

by:
Jamie McAllister MVP earned 500 total points (awarded by participants)
ID: 41870502
This can be painful for some users. It is possible for IT to raise the limit a little beyond 5000 without risk. 6 or 7k would be possible.

Beyond that you have to work with users to restructure libraries and views to work with the limitation. Basically a view will no longer work right if returning items more than threshold. So you need to have filters based on indexed columns to reduce the views below this level. Basically the first filter condition in the view needs to be based on an indexed column and sufficient to reduce the count below threshold. (Not multiple filters, the first is the key).

You can also introduce sub folders in some cases, or move content across libraries.

More painful can be that some filtering might not work even though the view itself is fine.

Not good I know.
0
 

Author Comment

by:vmccune
ID: 41870513
OK. what If I want to send to Excel.  Can I set it up to go to a PowerPivot table and can I subscribe this and have it run daily?
0
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
ID: 41870545
In Central Admin you can nominate a time period to relax the Threshold. I'd set jobs to run during that window.

Even export to excel is going to fail if threshold is exceeded.
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 

Author Comment

by:vmccune
ID: 41870679
No I get that.  What I mean is can I set it to go to a PowerPivot table instead of just Excel and make it a subscriptoion.
0
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
ID: 41870704
You could code a macro in Excel to do the pivot, you're not going to get it directly from SharePoint. That's not threshold related though.
0
 
LVL 31

Expert Comment

by:Jamie McAllister MVP
ID: 41895647
Feedback on filtering and indexing given.
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
I used to be SharePoint evangelist in our company, so my Outlook always full of questions about how to do this, or where I can find that. One day I found such an email with the following question: "how to attach 3-State workflow (one of the workflow…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now