Save a Read Only copy

Excel Tip - Read Only 0

When we have created a wonderful #Excel template that is to be shared with others, we don’t want users to distort, if not destroy, the template someday.  Nevertheless we would like to leave as much “flexibility” as possible to users by not password-protecting anything on the template.  We know that some users are super creative to crack a password-protected sheet/book. 😛

Here comes Read Only to rescue.

It is simple to make a READ ONLY file.  Save As (as usual)…

  1. Open the drop-down of “Tools
  2. Select General Options…

Excel Tip - Read Only.PNG

Assign a password to modify

Excel Tip - Read Only 1.PNG

Reenter your password to confirm –> OK –> Save

Excel Tip - Read Only 2.PNG

That is it.

When someone opens the file again, Excel will ask for a password for write access.

Excel Tip - Read Only 3.PNG

If you are the file owner and you plan to edit the file, you may enter the password to continue.

However if you do not know the password, you have no choice but open a “Read Only” copy.

What is a Read-Only Workbook?

Excel Tip - Read Only 4.PNG

Isn’t it clear?

With Read-Only template, we don’t have to worry about our wonderful template being ruined by someone in unknown way. Simply ask them to start over with the unchangeable Read-Only template originally shared.

As simple as this. 🙂

Did you know…

In old days, we needed a sticker to cover a specific location to write-protect a floppy disk.

Excel Tip - Read Only 5.PNG

btw… have you seen a real floppy disk? 🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Excel Tips and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.