Excel Read only message

Question

When I edit an Excel file I have created with Office 2019 and saved on my local drive then try to save it I receive the error message 'Cannot access read-only document' 'Read only' is not checked in the Save, Tools, General Options or in Properties. Any help welcome!

Answer 1

Thank you Gunasekar, the Trusted Locations solution solved the problem. The unblock option is not available in Office 2019.

Wish I'd asked you a lot earlier!

Answer 2

Hello SandiReed25,

I’m Gunasekar and I will be happy to help you with your question, I am a Microsoft consumer like you.

If you've arrived at this article because you got an error message that excel can't read a file or that the workboot cannot be opened, it's likely that Microsoft 365 has blocked the file for security reasons. You can unblock the file so it can be opened:

1. Here are the guidelines below to unlock your file.

https://support.microsoft.com/help/7f2f31e2-d4dd-4c1f-9e27-ba6fadf92d44

2. If you are still having issues, add a trusted location in Microsoft Office is a folder that contains files you trust to be safe.

a. In your Office app, click File > Options.

b. Click Trust Center > Trust Center Settings > Trusted Locations.

c. Click Add new location.

d. Click Browse to find the folder, select a folder, and then click OK.

Re-open the document and check if it helps.

Here's the article for your reference: https://support.microsoft.com/help/7ee1cdc2-483e-4cbb-bcb3-4e7c67147fb4

I hope this information helps. If you have any questions, please let me know and I’ll be glad to assist you further.

Best regards,

Gunasekar N