Colors Change After Replacing Data Source

Published: 21 Mar 2014
Last Modified Date: 31 Jan 2020


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


Tableau Desktop 


Option 1

Upgrade to a recent version of Tableau Desktop. Click here for downloads of current and previous versions of Tableau Desktop: Tableau Desktop Downloads and Release Notes.  For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.

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 different versions of Tableau Desktop. 
Did this article resolve the issue?