Error: "Tableau Data Engine Error: 505" When Connecting to Excel on Windows

Published: 16 Sep 2017
Last Modified Date: 17 Jan 2018


When connected to Excel, the following error may occur in Tableau Desktop: 

Tableau Data Engine Error: 505.


  • Tableau Desktop
  • Windows
  • Excel


  1. Close all instances of Tableau Desktop. 
  2. Navigate to the Tableau caching folder: 
    • Bydefault: C:\Users\<username>\AppData\Local\Tableau\Caching 
    • Note: If you are unable to see the AppData folder, you will need to configure the Windows settings to show hidden files and folders. For more information, see Show hidden files (Microsoft Help article)
  3. Delete the contents of the following folders: TemporaryExtracts and ExternalCacheV1
Did this article resolve the issue?