Maintaining spreadsheet security whilst performing data connection refreshes
Posted on 2016-11-01
When you protect a spreadsheet with "protect sheet" & "protect workbook" to effectively protect your IP. It seems that you need to lift all the protect to allow data connections to update.
Is there a recognised work around for this that would stand up to a penetration test?
All I can think of is a VBA script to perform the following
Update all connections
All the user has to do is press the escape key to interrupt the script during the data update and the security is no longer applied
I am sure there has to be a better way to update multiple data connections maintaining spreadsheet integrity