Jan 19 2021 11:42 PM
Hi all
I have the following situation:
* Excel workbook that have Power query sourced from SQL / Web
* User has edit permissions
* From time to time I need the capability to prevent the user from opening the excel
* Excel file is encrypted
I want to implement a mechanism that will allow me to set and change the password dynamically.
My implementation thoughts (sorted per my preference 1st is best approach)
* Excel offline with admin features
* Excel Online using permission (need to verify if I am able to prevent download and enable edit)
* 3rd Party that support such requirements
* Add another layer to the Excel Open password where the 'Code' would hold the Actual password and the user authentication would be confronting a server
Any thoughts