Colors Change After Replacing Data Source

Issue

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

Environment

Tableau Desktop 9.2 and earlier versions

Resolution

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:

Open the workbook in Tableau Desktop.
Open each sheet and wait for the sheet to load.
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.