Forum Discussion
Is there any way to make Excel files open Read Only by default when using the Web or Teams?
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.
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 Replies
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
SergeiBaklanThat's what I was looking for. Thanks.
Kelemvor333 , you are welcome
Hello Kelemvor333,
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.
