Solved

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

Posted on 2016-11-02
6
23 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
Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

 

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

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.

Question has a verified solution.

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

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
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…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

695 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