KNOWLEDGE BASE

Error "RGB color is invalid" When Working with an Excel file in Tableau Desktop


Published: 23 Apr 2018
Last Modified Date: 24 Apr 2018

Issue

When using the Data Interpreter to clean data in an Excel file, the following error occurs:

RGB color is invalid

Environment

Tableau Desktop

Resolution

Clear color formatting in the Excel file prior to connecting to the Excel file in Tableau Desktop.

Cause

Excel color formatting is incompatible with the Tableau Data Interpreter.
Did this article resolve the issue?