Solved

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

Posted on 2016-11-02
6
22 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 32

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 32

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
Office 365 Advanced Training for Admins

Special Offer:  Buy 1 course, get 2nd free!  Buy the 'Managing Office 365 Identities & Requirements' course w/ Accelerated TestPrep, and automatically receive the 'Enabling Office 365 Services' course FREE!

 

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 32

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 32

Expert Comment

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

Featured Post

Office 365 Training for Admins

Learn how to provision tenants, synchronize on-premise Active Directory, and implement Single Sign-On with these master level course.  Only from Platform Scholar

Question has a verified solution.

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

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

738 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