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.