Excel Add-Ins with password protected spreadsheets

Highlighted
Contributor

Excel Add-Ins with password protected spreadsheets

Hi, does anyone know if there are any workarounds when using the Excel Add-In, if you want to password protect your spreadsheet?

We have an end user who wants to do this, but is getting error messages when the spreadsheet is password protected (fine when he takes the password protection out).

 

Thanks, Andrew.

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Excel Add-Ins with password protected spreadsheets

@MagaliP 

 

Can you help @AndrewClark 

Highlighted
Certified Master Anaplanner

Re: Excel Add-Ins with password protected spreadsheets

Hi,

 

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!
Highlighted
Certified Master Anaplanner

Re: Excel Add-Ins with password protected spreadsheets

I found this idea which looks similar: https://community.anaplan.com/t5/Idea-Exchange/Password-protection-to-Excel-Add-ins/idi-p/51468

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!