KNOWLEDGE BASE

Resolving “Error sending crosstab to Excel” Error


Product(s): Tableau Desktop
Version(s): All
Last Modified Date: 16 Aug 2016

Article Note: This article is no longer actively maintained by Tableau. We continue to make it available because the information is still valuable, but some steps may vary due to product changes.


When exporting your text table from Tableau Desktop to Microsoft Excel using the Crosstab to Excel option, you may see an “Error sending crosstab to Excel” error message. This error message displays for one of the following reasons:

  • Excel is not installed: You do not have Excel installed on your machine.

    When using the Crosstab to Excel command, Tableau will automatically launch and paste a crosstab version of the current view in Excel. To export your view using the Crosstab to Excel option, Excel is required. If you do not have Excel, consider other export options.

  • Insufficient memory to export marks: Your machine has insufficient memory to export all the marks to Excel. Because each mark in the view corresponds to values in the underlying data, exporting a large crosstab to Excel that contains many marks can quickly exhaust memory.

    If you are experiencing memory related issues, you may also see other memory related errors while working with your workbook. For more information about memory related issues and potential solutions, refer to the Out of Memory Errors in Tableau Desktop article.

 

Alternate Search Terms:export, excel, crosstab, cross-tab, cross tab, text table
Did this article resolve the issue?