Multi year calculation for cube views connected via excel add in

[rpc2023]

When end users utilize the excel add in functionality, they are only able to calculate 1 year at a time using the calculate button. 

Is there a solution to allow users to calculate all (multiple) years shown on the cube view with a click of 1 button in the excel add in?

[JackLacava]

You could write an Excel matro that uses a REST Api call to kick off a Data Management task (which accepts a Time filter you'd set as Parameter).