Sep 01 2023 08:36 AM
I have an excel file that is shared on onedrive. I want users to be able to make changes to certain cells, but not to be able to SAVE those changes (unless they change the filename). I have it set to read only, but users can bypass this by selecting the "edit anyway" button.Is there a way that i can disable or hide the "edit anyway" button? Alternately, is there a way to prevent changes to the file from auto-saving on one-drive and requiring a password to make any changes?
Thanks,
Sean
Sep 01 2023 11:32 AM - edited Sep 01 2023 11:32 AM
It sounds like you're using "read only recommended". You need a 'password to modify'.
File | Save As window | Tools | General Options | Password to modify
Sep 01 2023 11:38 AM
thank you for the response. but i don't want them to need a password to use the spreadsheet (to modify the contents of cells), i just don't want them to be able to save those modifications to the same file name.
Sep 01 2023 11:53 AM
If you specify a "password to modify", users can still open the workbook without needing the password. In that situation, the workbook will be read-only for them without an option to edit, just like you want.
But those who need to edit the workbook will have to provide the password.
Sep 01 2023 12:28 PM
Sep 01 2023 12:44 PM
When the user opens the document as read only, they can still edit the workbook.'But trying to save the workbook will cause Excel to display a warning:
After that, the Save As dialog will be displayed.
Another option would be to save the workbook as an Excel template. Excel will then create a new copy when the user double-clicks the template.