Solved

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

Posted on 2016-11-02
6
18 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
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…

785 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