KNOWLEDGE BASE

Necessary Driver not Installed when Upgrading Microsoft Office to 365 Pro Plus


Published: 30 Oct 2017
Last Modified Date: 05 Dec 2017

Issue

Connecting to or exporting Microsoft Office data no longer works when Microsoft Office 2010 is upgraded to Office 365 Pro Plus, and the following error might occur: 
"There was a problem connecting to the data source "<Microsoft Access Data Source>". Try editing the data source.

Environment

  • Tableau Desktop 10.4
  • Tableau Desktop 10.0.1
  • Windows XP
  • Windows 7
  • Excel
  • Microsoft Access

Resolution

Installing the 'accessruntime_x64_en-us.exe' driver resolves the issue.

Cause

When Microsoft Office products are updated from 2010 edition to 365 Plus, Excel expects that data will be in cloud/network storage. This results in the 'accessruntime_x64_en-us.exe' driver not being installed on the local computer.
Did this article resolve the issue?