How to change only read Excel file to Editable

When you try to make changes to an Excel file but are met with an error stating that the file is marked as read-only, there are a few ways you can get around the restriction. Setting a file as read-only helps when you’re sending files to colleagues or friends and want to prevent changes to the content, but in some cases, it’s a hindrance. The process you use to address a Microsoft Excel read-only problem depends on how the file was made read-only, but in any case, it is straightforward.

Step 1: Go to the ‘File’ tab and select ‘Save As’.

Step 2: Select ‘Browse’

Step 3: Click on the ‘Tools’ drop down at the bottom of the ‘Save As’ dialog box.

Step 4: Select ‘General Options’ from the list.

Step 5: Uncheck the ‘Read-only recommended’ box in the ‘General Options’ dialog box and click ‘OK’

Select ‘Save’.

How to create a ‘READ-ONLY’ file

Step 1: Go to the ‘File’ tab and select ‘Save As’.

Step 2: Select ‘Browse’

Step 3: Click on the ‘Tools’ dropdown at the bottom of the ‘Save As’ dialog box.

Step 4: Select ‘General Options’ from the list.

Step 5: Make sure the ‘Read-only recommended’ box is checked in the ‘General Options’ dialog box and click ‘OK’

Select ‘Save’.

Leave a Reply

Translate »
%d bloggers like this: