Updating data trough Excel Add in

Hi all,

i have an urgent question: i'm actually trying to import a monthly cost report trough excel add in, the goal is to have a report which I can refresh every month.

The problem is that I would like to exclude all the empty cells of the module/view, so during the import trough add in I can see only the full cells.

Is it possible?

Accepted answers

All comments

JaredDolich

@Alessandr092

Great question. Let's also add our pro @MagaliP just to make sure there isn't a better answer.

I think the functionality is close to what you're asking for. Excel will only update the cells that have changed since your last refresh. It will not send the blanks or zeroes if they are the same as when you refreshed. Does that get you what you need?

In this example I only updated two of the months. And, only those two months were sent to Anaplan.

Alessandr092

Hello Jared, thank you for the quick reply.

I downloaded trough excel add-in a module, then I used filters and pivot to change the view directly in excel (with Anaplan filters). I used FLT_ZRO formula but the excel report still contain 0/blank cells.

I would like to exclude zero/blank values, and choose just the valorized cells.

I thought first I could save a view (because pages are not included in the add in scroll down menu) but I'm not able. If this is the best solution, can you give me a tutorial?

Thanks for all

MarkWarren

What does the saved view look like in Anaplan, can you set it up there as you would like to see it?

Alessandr092

I'm using a module, not a saved view, for the import trough add in. When I import data trough model, I see all the cells, but I wan't. I would like to see only valorized cells.

JaredDolich

@Alessandr092

I like where @MarkWarren is going. Can you use a Boolean value to filter on the month totals that equal zero? add that filter to your saved view. Just remember though, using a saved view with the Excel add in means you can't edit the view. Instead you might try using the Excel Add-In filter but you have to select the default view of the module.

Does that get you closer?

Alessandr092

Thank you all for helping me, probably the best solution for my problem is creating a custom view for single department.

When we produce monthly cost report, we need to keep apart every department because are confidential data (every department can't know the other departments expenses).

With the previous tool (BPC) we could exclude empty/zero cells, select the single department and refresh data every month: was not waste of time.

Now, if administrators won't create for us a number of custom view as the departments number, we're going to modify every month the add in extraction manually (filtering values, changing columns order, etc.).

MagaliP

Thank you for your feedback. I would recommend raising this suggestion on the Idea Exchange so that it gets visibility from other community members and you can also track its status.

I update the status regularly if and when suggestions move to the roadmap and are delivered.

Ideas delivered are also included in the version information page.

Ideas are published every month in the Extensions bulletin.

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