Excel Add In User Security Read/Write

Highlighted
Certified Master Anaplanner

Excel Add In User Security Read/Write

Hi, does anyone know if User Read/Write definitions from an Anaplan Model translate to Excel Add In?

 

If a user only has read access to an input module, that user then creates a connection to that input module with the Excel Add In, if they chose to create a read/write connection, would they have only read access, or would they have write access as well?

 

Is the follow statement true: User who only has read access to a module, should in no way have the ability to write back to Anaplan using the Excel add in.

 

Any info on user security with the Excel Add In would be helpful. I referenced Anapedia, but wasn't able to find anything that could answer my questions.

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: Excel Add In User Security Read/Write

@Blake_R 

 

Excel add in does respect the read/write security access on the modules - meaning even if the user creates read/write connection he can not send any data back to anaplan. This has been discussed in detail in below post

 

https://community.anaplan.com/t5/Anaplan-Platform/Excel-Add-in-3-2-vs-3-3-vs-3-4/m-p/61433#M11198

 

Hope this helps

Misbah

Highlighted
Certified Master Anaplanner

Re: Excel Add In User Security Read/Write

Awesome! This is great!

 

Thank you @Misbah 

Highlighted
Certified Master Anaplanner

Re: Excel Add In User Security Read/Write

Hi,

 

To confirm: all the security settings in the add-in are based on Anaplan settings (model role, selective access, dynamic cell access) at the moment.

 

Even if you create a read/write connection in the add-in, cells will not be editable if they are not in Anaplan. The same thing applies if you create such a connection (and you have write access) and then send the file to a colleague who has read-only access, they will not be able to send data back into Anaplan.

 

I hope this helps.

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!