SharePoint List Export to Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1931373%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Export%20to%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1931373%22%20slang%3D%22en-US%22%3E%3CDIV%3E%3CDIV%3EAfternoon%20all%2C%20I'm%20pretty%20stumped%20here....%20I%20have%20a%20list.%20I%20filter%20on%203%20Columns.%20Business%20Stream%2C%20UserType%20and%20Created.%20All%20are%20indexed.%20In%20Created%20if%20I%20do%20%5BToday%5D-28%2C%20Business%20Stream%20equal%20to%20%22Business%20Stream%201%22%20and%20UserType%20equal%20to%20%22FIELD%22....%20The%20View%20works%20it%20has%201185%20items%20and%20I%20can%20export%20to%20Excel.%20If%20I%20change%20Created%20filter%20to%20%5BToday%5D-29%2C%20the%20view%20works%2C%20I%20get%201244%20items%2C%20but%20I%20can't%20export%20to%20excel%20with%20the%20error%3A%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3E%22You%20do%20not%20have%20permission%20to%20view%20the%20entire%20list%20because%20it%20is%20larger%20than%20the%20list%20view%20threshold%20enforced%20by%20the%20administrator%22%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAny%20ideas%3F%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1931373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor
Afternoon all, I'm pretty stumped here.... I have a list. I filter on 3 Columns. Business Stream, UserType and Created. All are indexed. In Created if I do [Today]-28, Business Stream equal to "Business Stream 1" and UserType equal to "FIELD".... The View works it has 1185 items and I can export to Excel. If I change Created filter to [Today]-29, the view works, I get 1244 items, but I can't export to excel with the error:
 
"You do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator"
 
Any ideas?
0 Replies