Hello all,
I have recently discovered Excel Add-in existence. I had a lot of questions but current trainings (or at least the ones i watched) do not provide answers.
First, I would like end-users to have only permission to retrieve saved views in order to prevent them to see technical items (not relevant as end-user). Is there any way to do so?
Then, I would like to know if it is possible to get in Excel cells the filters (dimensions) so i would be able to create an excel sheet in which i will set the parameters (Year for instance) and then do the link required directly in the filters in each work sheet (as below)

Last but not least, i would like to know if there is any list of existing formulas related to the use of Anaplan Excel Add-in? For instance, the formula below retrieves the dimension needed (French Excel, equivalent in English is choose)

Thanks for your help !
Nicolas