KNOWLEDGE BASE

"Errors occurred while loading the data source...Unable to properly calculate the domain for the field '<field>" using Excel


Published: 23 Aug 2017
Last Modified Date: 06 Jul 2018

Issue

When you try to open a workbook that uses a Microsoft Excel data source, the following error occurs:
An error occurred while communicating with the data source.
Errors occurred while loading the data source.
Unable to properly calculate the domain for the field '<field>'. Displayed data may be incorrect.

Environment

  • Tableau Desktop 
  • Windows 
  • Excel

Resolution

  1. Open the Excel file in Microsoft Excel. 
  2. If it opens in Protected View, click the Enable Editing button, then save the file. 

 

Cause

The Excel file was in protected view. 
Did this article resolve the issue?