Error: "Errors occurred while loading the data source" When Attempting to Connect to an Excel File that Contains Slicers

Published: 22 Aug 2017
Last Modified Date: 24 Aug 2017


When trying to connect to an Excel file containing slicers, the following error occurs:

Errors occurred while loading the data source


  • Tableau Desktop
  • Excel


Option 1

Remove all slicers from the Excel file. Then try to connect to the Excel file again. For more information about how to remove the slicer, see Use slicers to filter PivotTable data.

Option 2

In Tableau Desktop on Windows, connect to the Excel file using the Microsoft Jet-based connection: 
  1. In the Open dialog box
  2. Click the Open drop-down menu
  3. Select Open with Legacy Connection.
Did this article resolve the issue?