All excel file suddenly become read only

kristoffergarne 

You can revert to the previous behavior where Excel prompts you whether to open a file as read-only or not. Here is how you can achieve that:

Method 1: Use the "General Options" Setting

1. Open the File in Excel.
2. Go to File > Save As.
3. In the Save As dialog box, click on Tools (located next to the Save button).
4. Select General Options from the drop-down menu.
5. In the General Options dialog box, check the Read-only recommended box.
6. Click OK.
7. Save the file.

Now, whenever you open this file, Excel will prompt you with the option to open it as read-only.

Method 2: Use File Properties in Windows Explorer

1. Right-click on the Excel file in Windows Explorer.
2. Select Properties from the context menu.
3. In the Properties dialog box, go to the General tab.
4. Click on the Advanced button.
5. Check the File is ready for archiving box (optional, for backup purposes).
6. Check the Read-only box to make the file read-only at the file system level. This is not recommended if you want the prompt.
7. Click OK to close the Advanced Attributes dialog box.
8. Click OK to close the Properties dialog box.

Note that this will make the file read-only by default, but you won’t get the prompt. It is better to use the first method if you want the prompt.

Method 3: Change the Protected View Settings

If Excel is opening files in read-only mode because of Protected View settings, you can change this behavior.

1. Open Excel.
2. Go to File > Options.
3. In the Excel Options dialog box, select Trust Center from the left-hand menu.
4. Click on the Trust Center Settings button.
5. In the Trust Center dialog box, select Protected View from the left-hand menu.
6. Uncheck the boxes for Enable Protected View for files originating from the Internet, Enable Protected View for files located in potentially unsafe locations, and Enable Protected View for Outlook attachments.
7. Click OK to close the Trust Center dialog box.
8. Click OK to close the Excel Options dialog box.

This will prevent Excel from opening files in read-only mode by default due to Protected View, but it will not bring back the read-only prompt. For that, you should use Method 1. The text and steps were edited with the help of AI.

My answers are voluntary and without guarantee!

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.