KNOWLEDGE BASE

Colors Change After Replacing Data Source


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

Issue

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

Environment

Tableau Desktop 

Resolution

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.

Cause

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