I've been working in technology for over 20 years in a wide range of tech jobs from Tech Support to Software Testing. I think I have the permissions set correctly. So, your file is saved as Read-Only. Do you any other ways? It could allow multiple users from editing a same file. So, when you click on a read-only Excel file password protected to open it, Password dialog box will appear. When we were making our Excel file read-only in our previous discussion, you had seen the General Options dialog box as the picture below. On the Review tab, in the Changes group, click Protect Sheet.
So, these are the ways to make an Excel file read-only and disable read-only from a read-only Excel file. It allows data to be changed but not saved apart from allocating a new file name. This new system is, as Markus says, ridiculous. Any other suggestions would be appreciated. If you do not like without your permission no one can edit or update your Excel file, you can make your Excel file read-only. Locate the file or folder on which you want to take ownership in windows explorer 2.
By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. A workbook is another name for an Excel spreadsheet file, whereas a worksheet is an individual tab of spreadsheet data within the file. Your workbook is read-only now. Now Owner name must have changed. If you have feedback for TechNet Support, contact. It would help many users who read this thread : Regards, Winnie Liang TechNet Community Support Please mark the reply as an answer if you find it is helpful.
I want to restrict my users from modifying the file. That means the user will be able to edit or update the file. I need it to save and overwrite the original. You may have to before you can post: click the register link above to proceed. So, if you don't want to make change to this Excel file, click on Yes to open it. You can then have all cells locked, protect the sheet and the users you have specified can edit anyway, without having to enter a password. Step 1: Open the Excel 2016 workbook.
However, these users can Save As this file to a new file in client machine though they don't have password on the original file. Generally, if you want to prevent your Wordbook from editing, please do the following settings for an Excel file: 1. Please understand that as it is an Office related question, it is more recommended to post to Office forum. As opposed to entering a password each time they attempt to change the spreadsheet? Are you still confused with protected sheet and workbook after removing open and modify password? The truth is, you are not able to fully protect your Excel file with just Excel. But it forces them to resave with a new name. All my data were on D drive.
Would this indicate it was a problem from the computer with the shared folder vs. Shaun Hi Shaun, I tested and got the same result as yours. Also malware bytes and windows defender for antivirus. Click on Security tab 4. Open the file at first, and try to save it using the option Save As. Click ok when Windows Security Prompt is displayed 10. If you don't want content reviewers to accidentally modify your document, you can make the document read only before sending it for review.
I gave the person an answer. Note: Above introductions have could help you to remove forgotten password from excel files. And its name is Read-Only. Restrict formatting and editing The following are the steps for a second method for helping to stop content reviewers from accidentally modifying your document. Everything seems to take 5 clicks now instead of 1 or 2 before. When I open the spreadsheet I am prompted for a password or I can select to Read Only. Way 3: Make an Office 2016 Excel spreadsheet read-only with sheet protection Step 1: Open the spreadsheet.
Any advice would be greatly helpful. It says: the file is reserved by someone. I can at least work with that but it was really throwing me for a loop. . Now click on Owner tab in Advance Security Settings for User windows 6. If you want to modify this Excel file, click on No to open it. I have tried changing the protected view in the trust center with no avail.
You will be able to insert, delete, rename, move, copy, hide or unhide worksheets, and change windows size or position in Excel file. I want people to be able to open, look-at and print the documents but not change them. Making your document a read-only file means that the document can be read or copied but not modified. Let me know if you have any ideas. Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? The file will be opened, but not as read-only. In that case, you can make your file read-only with a password. The file will be opened and you will not see the Read Only anymore.