Hello experts,
I have an Excel for Mac 2016 spreadsheet that is fully locked with a password except for a specific range. It works perfectly with entries in the unlocked range only, but when I upload it to OneDrive and open it directly from OneDrive the whole spreadsheet is unlocked and everything (formulas, formats etc.) can be edited.
I would like to share the spreadsheet in a locked version, so only the range is editable.
I have searched for answers and it seems there could be some kind of problem with a spreadsheet being created in Excel for Mac and then being opened in a different Excel (eg 365).
Any ideas?
I have an Excel for Mac 2016 spreadsheet that is fully locked with a password except for a specific range. It works perfectly with entries in the unlocked range only, but when I upload it to OneDrive and open it directly from OneDrive the whole spreadsheet is unlocked and everything (formulas, formats etc.) can be edited.
I would like to share the spreadsheet in a locked version, so only the range is editable.
I have searched for answers and it seems there could be some kind of problem with a spreadsheet being created in Excel for Mac and then being opened in a different Excel (eg 365).
Any ideas?
