Runtime error 1004 this file s locked

Question

I have a problem with an Excel file that won't allow you to save. There are no errors when loading or looking, only when I try to save.

The full error is

Run-Time error '1004'

this file is locked. Try the command again later.

The file is on a shared drive, and others can edit and save the doc.

I have looked for the file that's meant to fix the error but can not find it.

And I have altered the trust settings.

This is on an up to date version of office 2019

[Moved from Excel/For education/Windows]

Answer 1

1: it is a network-shared drive

2

3: any in this folder

4: office pro

5:I don't believe it is protected.

Also, I forgot to mention we did check the permissions and tried an older file. He also had permission to access any file the Excel needed.

Hi PerryJ2

Thank you for the information!

Your issue is quiet advanced and need a special attention from our Excel experts, please post your concern on our Office Q&A website and our Excel experts will provide a fix to your concern.

• Microsoft 365 - Microsoft Q&A

Sincerely

Juhn Jac

Microsoft Forum Moderator

Answer 2

1: it is a network-shared drive

2

3: any in this folder

4: office pro

5:I don't believe it is protected.

Also, I forgot to mention we did check the permissions and tried an older file. He also had permission to access any file the Excel needed.

Answer 3

Hi PerryJ2

Greetings!

Thank you for posting in Microsoft Community.

We understand that this situation is difficult, and it might be affecting your business let’s work on this together as team to get to the bottom of this.

For me to better understand the issue, I’d like to ask a few questions:

1. Can you please specify the drive where it was shared to collaborate with others?
2. Please provide screenshot of the error message.
3. Is this only happening to a one specific file?
4. Please provide the exact edition of your Office 2019 version. ex. Office 2019 Home and Business
5. Are you working on a protected workbook?

We look forward to your reply.

Sincerely

Juhn Jac

Microsoft Forum Moderator