Excel Add-in options

0 Kudos

Excel Add-in options

 

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

The best could be filter directly trough add-in options which data we want to keep and wich ones we want exclude.