KNOWLEDGE BASE

Unable To Set Layout, Columns Order, Rows Sort Order When Copying To Excel


Published: 28 Aug 2018
Last Modified Date: 29 Aug 2018

Issue

When copying a worksheet by using Ctrl + C and pasting it into Excel, there are no options to set the layout, sort order or column orders.

Environment

  • Tableau Desktop
  • Excel

Resolution

Follow these steps for a possible workaround:
  1. Create a text table which has the desired layout.
  2. Click Worksheet > Copy > Crosstab.
  3. Then, copy and paste this worksheet into Excel.

Cause

The ability to set the layout, sort order, or column order when copying & pasting a worksheet into Excel does not currently exist.
Did this article resolve the issue?