Error: "Errors occurred while loading the data source" When connecting to Excel files

Published: 10 Aug 2017
Last Modified Date: 09 Dec 2018


When connecting to Excel files, the following error might occur in Tableau Desktop:

"Errors occurred while loading the data source"

Additionally, you notice that this error occurs with several Excel files, but not with all of them.


  • Tableau Desktop
  • Excel


To resolve this issue, please follow the steps below:
  1. Open the affected Excel file.
  2. Copy the whole data.
  3. Paste the data into a new Excel file.
  4. Save this new Excel file.
  5. Connect Tableau Desktop to this new Excel file.
The error should no longer occur and the connection should be successful.


The Excel file is corrupted.
Did this article resolve the issue?