When entering a password, make sure that you don't enter something that you When Excel marks a file as read-only, the user must save any modifications in a 

Make a Word document read-only by restricting editing and formatting. reviewers tries to make changes to a read-only file, the changes can be saved only by giving Add or remove protection in your document, workbook, or presentation  How to Save Excel 2010 as read only - YouTube

Opening a file Read only via a shortcut - Excel Help Forum Hello All, I would like to be able to right click on an Excel file to create a shortcut then adjust that shortcut to open the file read only. I have tried to put the '/r' in front of the file name in the target area but get a message that the fiel name is not valid. I have also tried to adjust a shortcut the the Excell program itself but that R Tutorial on Reading and Importing Excel Files into R (article)

You can make a spreadsheet in Excel read only for others if you're concerned about other people editing it accidentally or intentionally without your permission.

Make a workbook read-only for everybody but me - Excel Off The Grid I gave the person an answer. However, the real question they were asking turned out to be "How can I make my workbook read-only for everybody but me". In this post, we will explore some of the options available. Save the file as "read-only recommended" There is a setting to save the file as read-only recommended. Excel 2019 & 2016: Force "Open as Read Only" Prompt - Technipages Excel 2019 & 2016: Force "Open as Read Only" Prompt Posted on November 11, 2018 by Mitch Bartlett 8 Comments If you have a file that is sensitive to changes, you can force Microsoft Excel 2019, 2016, or 365 to prompt the user to open as Read Only whenever they attempt to open the file.

When you open a read-only recommended Excel file, you will be prompted to open this Excel file in read only mode, unless you need to make changes to this Excel file. So, if you don't want to make change to this Excel file, click on Yes to open it. Excel 2019 & 2016: Force "Open as Read Only" Prompt - Technipages Excel 2019 & 2016: Force “Open as Read Only” Prompt Posted on November 11, 2018 by Mitch Bartlett 8 Comments If you have a file that is sensitive to changes, you can force Microsoft Excel 2019, 2016, or 365 to prompt the user to open as Read Only whenever they attempt to open the file.

I am having the same problem with my Mac. I imported a bunch of files into dropbox and now excel insists on trying to open them all read only. if I move the file out of the dropbox folder, it opens fine. It is only in the dropbox folder that it screws up. Excel shared workbook: How to share Excel file for multiple users