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

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.
vmccuneAsked:
Who is Participating?
 
Jamie McAllister MVPConnect With a Mentor SharePoint ConsultantCommented:
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
 
vmccuneAuthor Commented:
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
 
Jamie McAllister MVPSharePoint ConsultantCommented:
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
vmccuneAuthor Commented:
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
 
Jamie McAllister MVPSharePoint ConsultantCommented:
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
 
Jamie McAllister MVPSharePoint ConsultantCommented:
Feedback on filtering and indexing given.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.