Last Modified Date: 30 Jul 2020
- Tableau Desktop
- Microsoft Excel 2016
ResolutionPlease use one of the following workarounds:
Option 1When the view you are exporting contains a lot of data, a dialog box opens asking whether you want to copy the formatting options. Choosing to exclude the formatting from the export may improve performance.
- In Tableau Desktop, select Worksheet > Copy > Crosstab.
- Paste the crosstab into an Excel spreadsheet.
Option 3Export the data as an Access database file, and then export the table from Microsoft Access to Excel:
- In Tableau Desktop, select Worksheet > Export > Data.
- Select a location and type a name for your Access database file.
- Click Save.
- Open the Access database file in Microsoft Access.
- Right-click the table in the Datasheet View and select Export > Excel.
- In the Export - Excel Spreadsheet dialog box that appears, specify the destination file name and format, and click OK.
Option 4Reduce the number of marks on the Tableau worksheet to reduce the amount of data exported.
CauseThe Export Crosstab to Excel option simultaneously copies and formats the data. If the view being exported contains a large amount of data, performance of the export can be affected.
- Microsoft Excel 2016 is often included with current subscriptions of Office 365.
- For additional information about exporting information to Excel, see the following article in Tableau Help: Export crosstab of data in the view to Excel.
- To voice your support for improving the performance of exporting crosstabs of data to Excel 2016 in a future product release, add your vote to the following Community Idea: Improve the performance when exporting from cross tab to excel using O365 on Tableau Desktop.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials