If you found this article helpful, and especially if you didn't, please use the feedback controls below to let us know how we can make it better. Office 2016 Office 2010 Office 2013 You may find that when you are opening files, they open as read-only. I checked the Properties and the Read-Only is not checked. When I go into File tab, it shows the permissions as anyone can change it. Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? Please, I beg you, test and confirm steps before posting solutions.
Depending on your network setup, the setting might be Enable Protected View for files originating from the Internet. By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. I don't believe this read-only issue is related to a share restriction, as we have not changed the way everyone was accessing and did not have the problem. To help protect your computer, files from these potentially unsafe locations are opened in Protected View. How to make a read-only template in Excel? Step 5: Click the Save button in the Save As dialog box. There may be a few things better in 2010, but there are 10x as many items that have been made worse, or harder to use. Enter a name in the File name: box.
Up until December we could update the file directly. Thanks for contributing an answer to SharePoint Stack Exchange! Are the file properties set to read-only? We have an Excel spreadsheet on a shared drive that we update monthly some users have 2003, some have 2007, but this has not caused a problem in the past. I cannot open my Access databases. I need to be able to edit the spreadsheet and so does one other person. Excel will, by default, open documents in Protected View from potentially unsafe locations that includes SharePoint, but doesn't include local or network drives. In this article, I will show you the method to make a read-only template in Excel. Also, a file cannot be created read only just because if you create a read only file you can never edit it.
My comment is that it does essentially do so but there is one thing I do not like. If the file is stored on OneDrive and your OneDrive storage space is full, you will be unable to save the document until you are under your allotted space. You can check the file properties by right-clicking on the file and choosing Properties. I am having to save it on my hard drive and upload everytime which gets confusing for all the other users on the company website. Why does Microsoft shoot itself in the foot, and us in the back, like this? This tutorial will show you how to save excel as read only.
From the General Options dialog box, click to place a checkmark beside Read-only recommended. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed. Our experts and community members are discussing this topic in our Click that link to head over there, see what they're saying, and participate in the conversation if you like. Here I will guide you to configure the save options when saving a workbook as a template, and make the Excel template read-only. Next stop Linux, free software or Apple. In the lower left hand corner of this window you will see a tools option. This tutorial will show you how to save an Excel file in a read only format Don't forget to check out our site for more free how-to videos! BitDefender, for example, has content on adding application exclusions here:.
When I open the spreadsheet I am prompted for a password or I can select to Read Only. Everything seems to take 5 clicks now instead of 1 or 2 before. This article was last reviewed by Ben on June 21st, 2018 as a result of your comments. You may need to check with your antivirus provider to learn how to adjust these settings. This is going to cause a pop-up window to open.
You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations. Try this: Assuming you are using SharePoint 2010, go to your document library's Settings, then click Advanced Settings. Usually when it is a share restriction, all files in that location will be read only. Click File menu and click Save As to open the Save As dialog box. It goes straight to Read Only and does not allow editing or saving. How to make a read only file read write? When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password.
Step 1 -- Choosing to Save As Here we have just finished creating a spreadsheet that contains some cost information. The content is in protected view Files from the Internet and from other potentially unsafe locations can contain viruses, worms, or other kinds of malware that can harm your computer. Reopen the spreadsheet, and now you will have the coveted read only function and a password to edit. If Office is not activated, or if your subscription has expired, you could be in read-only Reduced Functionality Mode. I want people to be able to open, look-at and print the documents but not change them.