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?

Thanks all

Accepted answers

JaredDolich

@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.

All comments

JaredDolich

@Alessandr092

Alessandr092

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

JaredDolich

@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!

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385