How to remove ‘read-only’
Let’s now turn to the task of how to remove ‘read-only’ recommendations from the file.
For instance, say it’s to add new data and make some calculations. This updates the metrics for the stakeholders that use the report.
We need to have a way to remove ‘read-only’ from our file in order to easily save the changes to the current filename.
One thing to note is that our workbook must not be open in ‘read-only’ mode for us to be able to actually save our changes after we remove ‘read-only’.
When we open a ‘read-only recommended’ file that it prompts us for a ‘Yes’ or a ‘No’ to the question of whether we would like to open as ‘read-only’ or not.
We need to click ‘No’ in order to be able to save our changes.
1: When opening the file, select ‘No’ when prompted.
2: Click on ‘File’, then ‘Save As’ and then click on ‘Browse’.
3: Click on ‘Tools’ at the bottom of the ‘Save As’ dialog box and select ‘General Options’.
4: Once the ‘General Options’ dialog box appears, uncheck the box next to ‘Read-only recommended’.
5: Then click ‘OK’ and the workbook is no longer in ‘read-only’ mode.
There are a couple of things to note about workbooks that are opened as ‘read-only’…
First, if we open a file in ‘read-only’ there is an indication at the top of the file in the filename that the workbook is, in fact, ‘read-only’.
Another thing to note is what will happen if we try and save changes to the same file that is in ‘read-only’ mode.
As you saw earlier, the only way to save changes to a ‘read-only’ file is by renaming it or saving it to a different location.