SharePoint 2013 Foundation On-Prem
This error is from Excel that is linked to a Tasks list which is now exceeded the LVT, which I previously increased to 10,000. I have the same issue with most of my views on the tasks list itself and even after reading a lot of articles regarding indexing, filtering results and this still doesn't make sense to me.
Moving to the server first and a standard view that is created with the following filters.
The list currently has 10447 items;
Completed = 9304
In Progress = 1142
Not Started = 1
ViewName: Task Cleanup
- Status (indexed) = Completed AND
- Modified <= [Today]-60
So with the view using a indexed column as the 1st filter and the filtered result is under the LVT, I am not sure why this view is having the error?
"This view cannot be displayed because it exceeds the list view threshold (10000 items) enforced by the administrator."
What am I missing?