KNOWLEDGE BASE

"Someone else is working in <file> right now" when saving in Excel


Published: 10 Aug 2017
Last Modified Date: 30 Jul 2021

Issue

When saving an Excel file on a network shared folder (\\DRIVE\DATA) in Excel, the error message follows:
"Someone else is working in <file> Please try again later"

Environment

  • Tableau Desktop
  • Windows
  • Excel

Resolution

Contact MS Support to see if they have any workarounds. Or Convert the Excel files to CSV.

Workaround
Use Legacy Connections- This only works in pre-2019.1 versions of Tableau Desktop as Microsoft ended support for Legacy Connections.

Cause

This is a limitation of MS Office and shared folders in Windows. When the folder is granted with "Change" permission, all Excel files are not savable. 

Additional Information

https://community.spiceworks.com/topic/2014051-excel-2013-someone-else-is-working-in-server-share-document-xlsx-right-now

https://social.technet.microsoft.com/Forums/office/en-US/824030f2-f20a-4ed9-b368-b052e8a26b30/excel-file-save-error-someone-else-is-working-in-file-right-now-please-try-again-later?forum=excel
Did this article resolve the issue?