I just created a pivot table on 10 million rows in a spreadsheet in Row Zero.
I can’t create a pivot table with more than 1 million rows in Excel, so this is great! What is the limit on pivot table rows in Row Zero?
I just created a pivot table on 10 million rows in a spreadsheet in Row Zero.
I can’t create a pivot table with more than 1 million rows in Excel, so this is great! What is the limit on pivot table rows in Row Zero?
Pivot table row limits depend on your plan. You can easily create pivot tables on millions of rows in a spreadsheet on any Row Zero plan, including the free plan. Our standard workbook supports 5GB of data which is typically 10s of millions of rows. Enterprise plans can scale to hundreds of millions or billions of rows depending on your needs.
Here’s more info on building big pivot tables in Row Zero.