

November 2, 2021

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

1 Guest(s)
