Error "changes could not be saved ... because of a sharing violation"

Published: 04 Jul 2014
Last Modified Date: 20 Jun 2017


When saving an Excel file to which Tableau Desktop is connected live, and Tableau Desktop is open, the following error might occur:
Your changes could not be saved to '<filename>’ because of a sharing violation. Try saving to a different file.


  • Tableau Desktop
  • Excel (.xls, .xlsx) files


Option 1: Continue to Use Native Connection

Close Tableau Desktop and then save the Excel file.

Option 2: Switch to Using Legacy (Jet-Based) Connection

For more information about differences between legacy and native connections and the benefits of using each, see Upgrading Data Sources.
  1. In Tableau Desktop, make a new connection to the Excel file:
    • Click Connect to Data.
    • On the Connect page, click Microsoft Excel, select the file that you want to connect to
    • Click the Open drop-down menu, and then select Open with Legacy Connection.
  2. Replace original data source with newly created data source. For more information, see Replacing Data Sources.

Option 3: Use an Extract Connection to the Excel File

  1. Create an extract of the Excel file.
  2. Save the workbook, close and then reopen Tableau Desktop.
  3. Save changes to the Excel file, then refresh the extract in Tableau Desktop to pull in new data. For information about creating and refreshing extracts, see Extracting Data.

Option 4: Disable Indexing For The Folder Containing the Excel File

  1. Right click on the folder that contains the affected Excel file or files.
  2. Click Advanced... button at the bottom of the window.
  3. Un-check "Allow files in this folder to have contents indexed in addition to file properties".


Tableau Desktop locks the file to prevent simultaneous changes. 
Did this article resolve the issue?