How To Make An Excel File Read Only In Office 365

Wednesday, December 25, 2019

How To Make An Excel File Read Only In Office 365

You can check the file properties by right clicking on the file and choosing properties. In the image above select a folder where you want to save your excel file.

Fix Problems Opening Documents In Sharepoint Libraries Office

How Do I Remove Read Only From An Excel Document

Help Prevent Changes To A Final Version Of A File Office Support

After selecting a folder you will get the save as dialog box as the picture below.

How to make an excel file read only in office 365.

In the password to modify box enter a password and click ok.
The first step in how to make a file read only is to enable the setting.
Open the file at first and try to save it using the option save as.

Files from the internet and from other potentially unsafe locations can contain viruses worms or other kinds of malware that can harm your computer.
You might need to save it as another file name if you have already named the document.
Click on the tools dropdown at the bottom of the save as dialog box.

Now i want to make this file read only.
Check read only recommended in following general options dialog.
Now if you make any changes on the excel file and want to save there would be a message that prompts you again to save a copy of the file and rename it.

Go to the file tab and select save as.
If prompted choose yes to update the file with the read only setting.
Click the read only recommended check box.

Are the file properties set to read only.
The content is in protected view.
Click on the tools button and click general options.

Save as read only.
If you only want to recommend users to open the excel file as read only without protecting it dont enter a password and check read only recommended.
Click the microsoft office button and then click save or save as if you have previously saved the document.

If the read only attribute is checked you can uncheck it and click ok.
Choose tools general options at the bottom of the window.
In the save as dialog box.

Click file save as in excel then in save as dialog select tools general options.
Select save.
Select general options from the list.

Select the check box for read only recommended then select ok.
How to make an excel spreadsheet read only in office 2016 posted by darren march 4 2016 in office when you share one excel workbookspreadsheet with others you may do not want the spreadsheet to be modified arbitrarily by unauthorized persons.
When a dialog appears and shows three options for you to choose after you double click the read only excel file just click yes and you could open excel file in read only mode.