Data protection is on the rise and has become a concern to most online users.
If using an Excel workbook or file is part of your daily routine, you will most likely be interested in learning how to protect your entire file instead of a single sheet.
Depending on the sensitivity and confidentiality of the data you work with, you could save much more than only your time and effort.
By protecting your Excel file, you control who can see and/or edit its’ contents.
It is a simple solution if you have a simple problem to solve. However, once the user accesses the file, they can either see or edit everything.
What you should be trying to achieve is controlling what precisely each user can see or edit in your Excel file.
In Excel, you can’t achieve this, unfortunately. At least not at the user level. You’d need to create individual carve-outs of your Excel file, protect it, lock/unlock the cells you’d want that file recipient to be able to access and send it over to them via email or internal chat.
Moreover, if you’d like to prevent users from seeing specific sheets or cell-range content, you’d need to play around with hiding/unhiding rows and columns - this is painful!
At Layer, we've developed a new way to collaborate in Excel.
You can select parts of your Excel file down to the cell level and decide which collaborators should have access to it.
Collaborators will then receive an email granting access to the Layer online spreadsheet editor and a downloadable Excel file containing only the cells you’ve decided to share with them.
They can edit the cells’ content directly in the Layer online editor or reply to this email with the updated .xlsx file if you need their input.
Say goodbye to exposed sensitive data and people editing the wrong data in your Excel files.
There’s so much more to Layer. Please keep reading and explore what we have in store for you!