知識庫

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


發佈時間 : 21 Jun 2022
上次修改日期 : 21 Jun 2022

問題

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

 

環境

  • Tableau Desktop 2021.4
  • Windows 10
  • Excel

解決方法

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.



 

原因

Connection to the Excel file may be broken after the file is edited.
這篇文章是否解決了問題?