Hi,
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.