From hidden rows to sheet protection passwords, Excel's "privacy" features are easily bypassed—encryption and deletion are much more watertight.
Locking is a handy function in Excel that allows users to lock specific or all cells in a worksheet to prevent any intentional or unintentional editing of them. You can easily lock cells in a sheet by ...
One of my users, let's call her Alice, reported that she couldn't edit an important Excel file - Excel reported that "Bob" had it locked. This file is on a CIFS share located on a NetApp filer. I was ...