Editing a Read Only Excel File 2018
How To Create A Read-Only File In Excel And How To Remove It As well!
Written by co-founder Kasper Langmann, Microsoft Office Specialist.
Sometimes we may take an Excel workbook that would be sensitive to changes.
For instance, Jake, who reached out to u.s.a. and asked:
I take an Excel file with some important functions. How can I share this file with my clients without allowing them to make changes to it?
Jake Kurtz In this instance, it will be necessary to protect the workbook from any changes intentional or otherwise by other users that accept access to it.
Nosotros may still want to allow a user to make changes and salvage those with a new filename or to a different location.
A great way to ensure the integrity of such a workbook file would be to enable the 'read-only recommendation'.
Kasper Langmann, Co-founder of Spreadsheeto *This tutorial is for Excel 2019/Microsoft 365 (for Windows). Got a different version? No problem, you tin yet follow the exact aforementioned steps.
What practice you lot want to learn?
How to create a 'READ-Simply' file
Let'due south say we maintain a monthly report that we make changes to as new information becomes available.
Nosotros now need to share the updated report to users that need the new data and metrics.
However, nosotros desire to make sure that any changes made past other users do not become saved to the original file. Instead, these users will be forced to rename the file – or to salve it to a unlike location.
Kasper Langmann, Co-founder of Spreadsheeto We tin practice this by making certain other users tin choose the option of 'read-only' manner to decrease (but not eliminate) adventure of the file beingness changed.
The kickoff pace in how to make a file 'read simply' is to enable the setting…
1: Go to the 'File' tab and select 'Save Every bit'.
3: Click on the 'Tools' dropdown at the bottom of the 'Relieve As' dialog box.
4: Select 'General Options' from the list.
5: Make certain the 'Read-just recommended' box is checked in the 'General Options' dialog box and click 'OK'
6: Select 'Relieve'.
It's that simple.
Now every time the file is opened, the user will be prompted to 'Open every bit read-merely?'.
Note: This method allows the choice of 'Yes', 'No', or 'Cancel'
If the user clicks 'Yes' to the question to open every bit 'read-just', no changes to the original file (name) can be made.
This doesn't quite mean that we cannot make changes to the open file.
For anyone wondering how to modify a 'read-only' file, in that location actually is a bit of a workaround.
Annotation in the next figure that if nosotros endeavour to save a 'read-only' file that it prompts united states to change the file name or location.
So that'south how to change a 'read-only' file!
We only rename the 'Save As' filename or salve it to a dissimilar file location.
It'southward a pretty simple procedure to save a workbook as 'read-only' and it adds some extra control over the workbook.
Kasper Langmann, Co-founder of Spreadsheeto But it'south really non protecting it from changes since each user that opens the workbook has the option not to open up in 'read-simply'.
It's more of a reminder to anybody who might forget that "hey, don't mess this copy upwards!".
Now that nosotros have covered the steps to make a workbook file 'read-only' let'due south expect at how nosotros remove the 'read-only' selection…
How to remove 'read-only'
Let's now turn to the chore of how to remove 'read-only' recommendations from the file.
For instance, say it'due south to add new data and make some calculations. This updates the metrics for the stakeholders that utilize the written report.
We need to have a way to remove 'read-only' from our file in order to easily save the changes to the electric current filename.
Kasper Langmann, Co-founder of Spreadsheeto One affair to note is that our workbook must not be open in 'read-only' style for united states to be able to actually relieve our changes subsequently we remove 'read-only'.
Remember…
When we open a 'read-but recommended' file that it prompts us for a 'Yes' or a 'No' to the question of whether we would like to open up as 'read-only' or not.
We need to click 'No' in guild to be able to save our changes.
1: When opening the file, select 'No' when prompted.
2: Click on 'File', then 'Save Equally' and and so click on 'Scan'.
3: Click on 'Tools' at the bottom of the 'Save As' dialog box and select 'General Options'.
4: One time the 'Full general Options' dialog box appears, uncheck the box next to 'Read-merely recommended'.
5: Then click 'OK' and the workbook is no longer in 'read-only' mode.
There are a couple of things to note near workbooks that are opened every bit 'read-just'…
Kasper Langmann, Co-founder of Spreadsheeto First, if we open up a file in 'read-simply' there is an indication at the summit of the file in the filename that the workbook is, in fact, 'read-only'.
Some other thing to note is what will happen if we try and save changes to the same file that is in 'read-only' style.
Every bit you saw earlier, the but mode to save changes to a 'read-only' file is by renaming information technology or saving it to a different location.
Conclusion
So, there information technology is. The bones steps to both enabling and disabling 'read-only' way in Excel 2016.
Information technology's a simple technique that tin can provide more control over the integrity of files without going to the extremes of things similar password protection.
Furthermore, it still allows other users to brand changes but ensures they can merely do so by renaming the file or saving it to a different location than the original file.
Kasper Langmann, Co-founder of Spreadsheeto Source: https://spreadsheeto.com/read-only/
0 Response to "Editing a Read Only Excel File 2018"
Post a Comment