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

Occasional Visitor

Hi,

 

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

Intentional_BI_0-1679432396356.png

 

Intentional_BI_1-1679432418132.png

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."

 

Intentional_BI_2-1679432809953.png

 

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