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.
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?
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.
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.).