Colors Change After Replacing Data Source

Published: 21 Mar 2014
Last Modified Date: 27 Jul 2018


After replacing a data source, colors that were previously defined revert to the automatic color palette.


Tableau Desktop 9.2 and earlier versions


Option 1: 
Upgrade to Tableau Desktop 9.3 or a newer version. For more information, see Upgrading Tableau Desktop

Option 2: 

Let all the sheets in the workbook load completely before replacing the data sources:
  1. Open the workbook in Tableau Desktop.
  2. Open each sheet and wait for the sheet to load.
  3. After all sheets have loaded, replace data sources. For more information, see Replacing a Data Source.

Option 3: 

Instead of removing and adding a table to the data connection in the Data Source tab, drag and drop the new table on top of the old table to be replaced.


Many issues with unexpected formatting behaviors when replacing data sources were corrected in Tableau Desktop 9.3.
Did this article resolve the issue?