The macro would be in a personal macro workbook Or I would. Generally, you'll need to set a password that will need to be entered to make changes to this file. It is the worst thing to happen to me, and that includes my divorce. Why does Microsoft shoot itself in the foot, and us in the back, like this? I read it differently from Kije. Double-click on the Excel file, enter password for write access.
How to make a file read only? Click on Edit Button and select user from given Change Owner to list if user or group is not in given list then click on other users or groups. To keep changes, they have to save this workbook with a new name or in a different location. In the lower left hand corner of this window you will see a tools option. The setting you want is in Excel, not in SharePoint. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password.
Now the workbook is saved as a read-only Excel template. If do not need the read only restrict password any more, follow the steps to remove it from Excel file. I cannot open my Access databases. I want people to be able to open, look-at and print the documents but not change them. It worked fine when I first used it andcould edit and save the spreadsheets with no problem. Double-click on the Excel file, and select No to open it. Expert: Brie Clark Filmmaker: Alexis Guerreros Series Description: If you're trying to create the best spreadsheet possible, look no farther than Microsoft's powerful Excel application.
It allows data to be changed but not saved apart from allocating a new file name. Click on Remove Password button. In this article, I will show you the method to make a read-only template in Excel. When the Excel file is opened as read only, and was made changed, it won't be able to save to the same file name on the same location, but it is able to be saved to another name and another location. The Open Dialog box could create the impression that you are dealing with a Read Only file.
Try this: Assuming you are using SharePoint 2010, go to your document library's Settings, then click Advanced Settings. About the Author Steven Melendez is an independent journalist with a background in technology and business. Step 5: Finally, press Ctrl + S to save the spreadsheet. Most of these files I use as reference, and will do some small calculations in the file for my own purposes. If don't need the read-only recommended on this Excel any more, how to remove it? Computer will need to reset to update settings, and give it a couple of minutes before trying to access your files, otherwise you may get some messages saying that access is denied.
About 6 months ago this changed, even if I select edit workbook it still opens as read only. But when I run Excel as an Administrator holding ctrl+shift and then open the excel file it opens with read and write permission. Click that little down arrow and select Open Read Only. Chris Hi Guys, Thanks for thinking about this and offering up some code. How do I remove the local Read-only attribute in Excel? Depending on your network setup, the setting might be Enable Protected View for files originating from the Internet.
Provide details and share your research! You can even limit formatting styles that can be used in the document. If you want to modify the Excel file, here will show you to make it editable. 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. Rightclick on the partition, folder or file s and select Properties. I open a file that's read only.
Next stop Linux, free software or Apple. You can delete the old Excel file, and rename the new Excel file name to the old one. Keep in mind that people may be able to copy data from the spreadsheet to another spreadsheet or file, and then edit it there if they wish to do so. This always open the file read only and even if you already made your file read only, by using the first option, this overrides it since this function is part of the operating system rather than the application. 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. My comment is that it does essentially do so but there is one thing I do not like. Click ok when Windows Security Prompt is displayed 10.
This is going to cause a pop-up window to open. You should select a file before using this option. It goes straight to Read Only and does not allow editing or saving. Click Ok for changes to take effect and click ok final ok to exit from Properties window. Add a non-excel file to the network location, such as word and see if that comes up as read only.