Can't export to Excel from a SharePoint list view filtered on a termset column

Occasional Visitor



I have a SharePoint list with a view filtered on a termset (managed metadata) column. See below




I can export the list to a CSV with 2,247 rows. However, if I export to Excel, I got an error: "You do not have permission to view the entire list because it is larger than the list view threshold enforced by the administrator."




I don't understand why the error occurred because the result is within 5,000 rows. I wonder if any of you have this issue before and what the solution is. 


Thank you.



0 Replies