Sep 07 2021 07:30 AM
Good morning everyone,
If I created an excel sheet, clicked protect sheet with password added, how come when others sent the excel sheet back to me, the "protect sheet" option is no longer there? It's as the sheet was never protected in the first place.
Is there anything I can do to prevent others from unlocking my sheet without password?
Thank you
*Excel version 2016 / Windows 10*
Sep 07 2021 07:35 AM
In Excel password protection is mainly to protect from people negligence. Such protection is relatively easy to remove.
Sep 07 2021 07:40 AM
Sep 07 2021 07:47 AM
I think so, if the person has enough skills (s)he could remove the protection. Yu may try yourself, the easiest way - upload protected file to Google Sheets and download it back as Excel file. Most probably protection will be lost. You may corrupt the file by such way, depends on formulae used, but there are other ways.