Share via

Excel-Read only without a password

Anonymous
2018-06-19T12:31:17+00:00

I have an Excel spreadsheet that I want users to be able to open without a password, yet not be able to make changes to it. Is there a way to do this?  Thanks for your help.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2018-06-19T14:56:44+00:00

Press F12 to display the Save As dialog.

Click the Tools dropdown to the left of the Save button, and select General Options... from the dropdown menu.

Leave the 'Password to open' box blank.

Enter a password in the 'Password to modify' box.

Click OK. You'll have to re-enter the password as confirmation. Do not forget it!

Now save the workbook; it's OK to overwrite the existing version.

When users open the workbook, they'll be prompted for the password. They can click the Read-Only button to open the workbook without providing the password.

Was this answer helpful?

10+ people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-06-19T15:51:04+00:00

    Thank you, Hans! Exactly the answer I needed!

    Was this answer helpful?

    0 comments