BASE DE CONNAISSANCES

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

Date de publication : 21 Jun 2022
Date de dernière modification : 21 Jun 2022

Problème

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

 

Environnement

  • Tableau Desktop 2021.4
  • Windows 10
  • Excel

Résolution

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.



 

Cause

Connection to the Excel file may be broken after the file is edited.
Cet article vous a-t-il permis de résoudre le problème ?    
PRINT THIS PAGE
Trending Articles
Results 1-3 of 49
Pièces jointes


Toute l'assistance

ASSISTANCE PAR PRODUIT
OUTILS ET TÉLÉCHARGEMENTS
INFORMATIONS
ASSISTANCE