KNOWLEDGE BASE

Error "The crosstab exceeds the size allowed and cannot be exported." Exporting to Crosstab


Published: 13 Nov 2017
Last Modified Date: 13 Nov 2017

Issue

When you try to export a large crosstab using "Export to crosstab" the following error occurs: 
The crosstab exceeds the size allowed and cannot be exported

Environment

Tableau Server

Resolution

Apply filters to limit the number of rows or columns you are exporting.
 

Cause

Excel has a built-in limit of 1,048,576 (row) x 16,384 (column) or 33,554,432 cells. Tableau Server has this limit coded in to avoid creating a file that Excel cannot accept. 


 
Did this article resolve the issue?