KNOWLEDGE BASE

Error Code EA3F4C1E Occurs When Opening .twb Workbook Connected to Excel Data


Pubblicato: 21 Jun 2022
Data dell'ultima modifica: 21 Jun 2022

Problema

When opening an unpackaged workbook (.twb) with a connection to Excel, the below error occurs, and could not open it.
This error occurs after the Excel file was edited. 

An error occurred while communicating with data source

Bad Connection: Tableau could not connect to the data source.

Error Code: EA3F4C1E

InsertData: unbound column

 

Ambiente

  • Tableau Desktop 2021.4
  • Windows 10
  • Excel

Soluzione

Please try the following workarounds.
Option 1
Download and install the latest version of Tableau Desktop and try to open the workbook again.
https://www.tableau.com/support/releases
Option 2
Follow the steps in the article below to clear the cache of Tableau Desktop.
Clearing the Tableau Desktop Query Cache
Option 3
Make a copy of the Excel file in a new directory and delete the original file.
Then open the Tableau workbook and you will be asked where your data source is.
Pick the copied Excel file saved in the new directory.



 

Causa

Connection to the Excel file may be broken after the file is edited.
Con questo articolo hai risolto il problema?