In the lower left hand corner of this window you will see a tools option. I need for approx 20 users to be able to read-only a workbook but to allow only 2 users to make changes to the workbook. . Next stop Linux, free software or Apple. Please can anyone advise if I make changes and save them down, will this update the data in the read-only versions or will the users have to re-open the file to keep checking for changes? Your workbook is read-only now. If you have to enter a password to open the document then you have not successfully set the document up for Read Only access.
Also See: I now have 2 excel spreadsheets i work from everyday, adding to them both and making them available to other work colleagues. Why does Microsoft shoot itself in the foot, and us in the back, like this? Why is my outcome different than yours? Office 2010 is absolutely incompetent, inefficient and stupid beyond stupidness. Click on the Tools button and click General Options. One was created with 2007 read only-perfect and the latest with 2010 which i have to lock so nothing happens to it. Note: If you only want to recommend users to open the Excel file as read-only, without protecting it, don't enter a password and check Read-only recommended.
When I open the spreadsheet I am prompted for a password or I can select to Read Only. By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. About 6 months ago this changed, even if I select edit workbook it still opens as read only. I have a Spreadsheet on a Shared Drive that I want everyone to have Read Only Access. I cannot open my Access databases. Reopen the spreadsheet, and now you will have the coveted read only function and a password to edit.
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. When I go into File tab, it shows the permissions as anyone can change it. Malicious users can edit the file and remove the password. This would be much better if it was similar to a protected sheet where an attempt to change a protectred cell would bring up a warning immediately. This new system is, as Markus says, ridiculous. My comment is that it does essentially do so but there is one thing I do not like.
I just know that I am not the only being on the planet who wants to do this. It goes straight to Read Only and does not allow editing or saving. Everything seems to take 5 clicks now instead of 1 or 2 before. It is the worst thing to happen to me, and that includes my divorce. Note: this feature does not encrypt your Excel file. So I want to have most people open it as read only and two of us use a password to edit the same spreadsheet.
Why is my version different than yours? I want people to be able to open, look-at and print the documents but not change them. This would display the following menu list Click on the Mark as Final menu, the following dialog box would appear. Can I do it with Microsoft? Any way the read-only versions can be updated automatically or the users can be advised the changes have been made and to refresh? 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. How do I make my spreadsheet editable to others without it being renamed? Please, I beg you, test and confirm steps before posting solutions. Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? It allows data to be changed but not saved apart from allocating a new file name. It worked fine when I first used it andcould edit and save the spreadsheets with no problem. Enter a file name and click Save.
I need to be able to edit the spreadsheet and so does one other person. But it forces them to resave with a new name. This is going to cause a pop-up window to open. When I try this on any other computer it opens the spreadsheet without giving the option to edit with a password. .
. . . . .