Re: Excel Add-Ins with password protected spreadsheets
Sorry for missing your message!
You are right that protected sheets cannot be refreshed. We could imagine this to be turned on and off as a setting though, so if you have a need for it, feel free to post your suggestion on the idea exchange.
I cannot think of a workaround I am afraid, because editing data (by refreshing it) is in direct contradiction with the sheet protection as per the current design.
I would be happy to discuss with you and to understand your process, to see if we can find some creative workarounds. I will direct message you.
Magali Pelissier, Product Manager - Extensions (Excel Add-in, PowerPoint Add-in, Google Sheets Add-on) Check out our dedicated Community page in the Platform section!