question

RJames2010-3295 avatar image
1 Vote"
RJames2010-3295 asked GrahamDLlewellyn-6987 answered

Excel file locked for editing after Save As

We have a single user who will open an Excel (O365 2002) file from a file share, save it as a different file name and then when she goes to open the original file, it's telling her that it's locked for editing. I checked on the file server and there were no temporary files and the file wasn't showing as being open in fsmgmt.msc.

I'm wondering if anyone has any ideas.

Thank you!

office-excel-itpro
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RJames2010-3295
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


0 Votes 0 ·
emizhang-msft avatar image
0 Votes"
emizhang-msft answered RJames2010-3295 commented

Hi @RJames2010-3295
How about opening the second time save as Workbook? Did you get the same message?
I suggest you go to Task Manager- End all Microsoft Excel tasks and re-open the problem Workbook.
Try to check if the user have different account permission for accessing the shared folder.
Disable firewall and antivirus software and test the result.
Any updates please let me know and I'm glad to help you.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

If the user opens the Save As workbook, that opens fine. It's the original workbook that is giving an error message.

I will ask the user to try to close all Excel tasks and re-open the file but that isn't at all a user-friendly solution.

I've verified the user's permissions to the shared folder and she has Modify permissions to the folder.

Neither the Firewall nor AV reported any blocks and we have the same Firewall/AV policies for other users who aren't having this issue.

0 Votes 0 ·

Closing all of the Excel tasks didn't help. The user did note that this only seems to happen with workbooks that have macros.

0 Votes 0 ·
GrahamDLlewellyn-6987 avatar image
0 Votes"
GrahamDLlewellyn-6987 answered

I have the same issue, and its only if we use "Save As" on a file from a network share.
Our situation is this:
A user exports data from an app, into a TXT file on the network share. Opens in in Excel 365, and does a Save As to convert into an XLSX.
The original TXT file on the share becomes locked.
Closing all of the users Excel windows WILL unlock the file, but that isn't acceptable.

If the user does the same actions, except start with the TXT file on the local computer....no locking.
I checked Open Files on the server where the share resides, and YUP - the owner file that starts with ~ says its open and locked.

This issue wasn't present until our users starting migration to O365.
I added the users network shares as a Trusted Location on the network, but no dice!

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.