Issue
When trying to connect to an Excel file containing slicers, the following error occurs:Errors occurred while loading the data source
Last Modified Date: 24 Aug 2017
Errors occurred while loading the data source
Environment
- Tableau Desktop
- Excel
Resolution
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:
- In the Open dialog box
- Click the Open drop-down menu
- Select Open with Legacy Connection.
Cause
Tableau does not support pivot tables in Excel. For more information about this data source, see Connector Example article for Microsoft Excel in Tableau Help.Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials