KNOWLEDGE BASE

Error "Microsoft JET database engine cannot open the file" Connecting to Excel Files on Sharepoint


Published: 12 Jun 2014
Last Modified Date: 02 Sep 2016

Issue

When connecting to Microsoft Excel files stored on Sharepoint, the following error may occur:

TableauException: Microsoft JET database error 0x80004005: The Microsoft Jet databse engine cannot open the file. <UNC path to file>
It is already opened exclusively by anothe ruser, or you need permission to view its data. Unable to connect to the Microsoft Excel file.


 

Environment

  • Tableau Server
  • Sharepoint

Resolution

Ensure the Microsoft Excel file is stored in Sharepoint's local file system in a location the Run As user has permissions to access.

Cause

The Excel file is stored in Sharepoint's SQL Server Content database, and does not have a physical file path.
Did this article resolve the issue?