Log In
Register
Home
November 2, 2021
Offline
Hi there,
I understand it's quite difficult to query encrypted workbooks (you have to write some VBA to open them in advance, remove the encryption, and then refresh the query), but is the same true for workbooks with protected ranges?
I'm having difficulty reliably loading data from a series of sheets which are protected (i.e. using the "Protect Current Sheet" rather than "Encrypt with Password" option on the "Protect Workbook" menu) These sheets are protected so that some ranges are editable and some are not (to prevent accidental changes to calculated cells), and unfortunately it's not an option to remove that protection.
Is there any way to reliably refresh power queries from those sheets without having to use a macro to un-protect and then re-protect them?
Thanks!
Ryan
Trusted Members
October 18, 2018
Offline
You will need to unprotect them either manually or with VBA. Then once you have refreshed the query, then protect either manually or with VBA
November 2, 2021
Offline
Thanks Alan - I was hoping that was only the case where the workbook was encrypted, but if not putting in some VBA shouldn't be too tricky. Just wanted to avoid the extra work if possible!
Thanks again
Ryan
1 Guest(s)
