Excel Add-in

Alessandr092
New Contributor

Excel Add-in

Hi all, 

for the monthly cost analysis, I would like to import a customised report via the Excel add in, so that every month I can only refresh the data.

When I select the data to be imported via the add in, the system only gives me the modules and views. Should I customise a view? If I customize it, will I be able to see it within the dropdown menu?

Alessandr092_0-1613995508304.png

Thanks all

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: Excel Add-in

@Alessandr092 

Adding pro @MagaliP . You are correct. here's the rule, below. If you want to use a saved view then you will have to take it as is, otherwise go build another saved view in Anaplan that meets your needs. Alternatively, you can use the default view and then pivot. 

ExcelAddInSavedView001.png


Jared Dolich

View solution in original post

3 REPLIES 3
JaredDolich
Moderator

Re: Excel Add-in

@Alessandr092 

Adding pro @MagaliP . You are correct. here's the rule, below. If you want to use a saved view then you will have to take it as is, otherwise go build another saved view in Anaplan that meets your needs. Alternatively, you can use the default view and then pivot. 

ExcelAddInSavedView001.png


Jared Dolich

View solution in original post

Alessandr092
New Contributor

Re: Excel Add-in

Thank you @JaredDolich for quick reply, so I've an other question: how can I create a custom view from the related module?

 

 

JaredDolich
Moderator

Re: Excel Add-in

@Alessandr092 

Two choices.

1. Create a saved view INSIDE of anaplan. Save the view exactly as you want it to appear in Excel, then use that saved view.

2. Use the default view of the module. That will allow you to pivot the view, filter, and the like.

Hope that helps. You got this!


Jared Dolich