KNOWLEDGE BASE

'Export to Excel' Returns Incorrect Results


Published: 02 Jun 2016
Last Modified Date: 04 Sep 2017

Issue

When using the 'Export to Crosstab' feature in Tableau Desktop on a blended worksheet, the results in Excel are not the same as in Tableau. Instead, all columns show the same values.

The issue occurs when a dimension that is being blended on in the primary data source is on the columns shelf.

Environment

  • Tableau Desktop 8.2 - 9.3
  • Microsoft Excel export

Resolution

Option 1

Upgrade to Tableau Desktop 9.3.7 or 10.0.1 or later. For more information, see Upgrading Tableau Desktop.

Option 2

The data can be copied and then pasted into Excel instead of using the 'Export to Excel' option. To do this, follow the steps below. 
 
1. Go to the Worksheet menu > Copy > Data
2. Open Microsoft Excel > Paste
Did this article resolve the issue?