Is there any way to make Excel files open Read Only by default when using the Web or Teams?

[Mike Boehm]

Hi,

We have some spreadsheets shared among a bunch of people that end up getting messed up now and then when people accidentally make changes.  We access them via Teams|Files or a shortcut to Excel Online.  These sheets don't change very often so I'd love to be able to set them to open in Read Only mode by default and then have someone have to manually enter Edit mode if they want to make changes.  Can that be done?

Thanks.

[#2]

Hello @Mike Boehm,

To turn on Read-only:

Go to File Explorer > Find your Excel Workbook > Right-click > Properties > Read-only > Apply

While this wouldn't completely prevent someone from changing your excel workbook, it could prevent accidental changes to the workbook. 

[#3 · Accepted solution]

@Mike Boehm 

In File->Info of Desktop app you may switch on

In Excel Online

If open in Desktop app it'll be like

And the same of open in browser

[#4]

@Sergei BaklanThat's what I was looking for.  Thanks.

[#5]

@Mike Boehm , you are welcome