Data protection, security and validation in excel

Question

It’s been several years now that users complain about protection options but nothing is done by microsoft: when protecting a sheet with an array, it does not extend automatically anymore however it would be convenient to have an option that leaves the possibility of the table to expand, for data validation a copy-paste can overwrite all data validation which makes this option completely unnecessary, We could have had an option to copy and paste on the cells unblocked. Finally the level of security is not reassured, the password protection sheet can be hacked and in onedrive one can not block the download on a personal account. It’s so disappointing because microsoft adds functions but does nothing about the existing problems !

Answer 1

Hi,

I understand your frustration.

Password-protected tables do have a risk of being hacked. For added security, you can use more complex passwords and change them regularly. Also, consider using sensitivity labels and information protection features in Microsoft 365 to further protect your data.

https://learn.microsoft.com/en-us/purview/sensitivity-labels

Currently, OneDrive really can't block downloads for personal accounts. You can restrict access to files by setting sharing permissions, but that doesn't completely prevent downloads.

It is recommended that you can also give a feedback to Microsoft :

https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11

https://support.microsoft.com/en-us/office/send-onedrive-feedback-594f538c-cb25-4079-b1f2-716d91d41bde

Microsoft values your opinion. Your feedback goes directly to our engineers and helps us shape the future of Microsoft products and services for all our users.

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.