Forum Discussion
Locking/stopping drill down in Pivot Table to Share
Protection in Excel is more protection from negligence to reduce risk of data corruption. That's not saves your data from someone who intentionally would like to access them.
You may do simple test - create Excel workbook applying kind of protection. Upload this workbook in Google Sheets in open in it. In 90% of cases protection is ignored. If you don't like Google Sheets save this workbook back as Excel one. Open in Excel, protection is gone.
Protection in Excel is more protection from negligence to reduce risk of data corruption. That's not saves your data from someone who intentionally would like to access them.
You may do simple test - create Excel workbook applying kind of protection. Upload this workbook in Google Sheets in open in it. In 90% of cases protection is ignored. If you don't like Google Sheets save this workbook back as Excel one. Open in Excel, protection is gone.
- Thank you. I will put this into a read-only Power BI only accessed by certain persons.
