The Analytics Edge Core Add-in can run a specific Analytics Edge macro from a button on your worksheet. This opens the door to interactive refreshes without having to navigate the Task Pane controls.
Starting with a workbook containing an Analytics Edge macro, add a Form Control Button to your worksheet.
When prompted for the Macro name, enter AnalyticsEdge.RunMacro
Note: the workbook can be saved with XLSX format. An Analytics Edge macro is not an Excel macro and does not require a macro-enabled workbook.
With the button still selected (right click on the button if you need to select it), change the button name to match the name of the macro to be run when you click the button. You enter the button name in the Name box, located to the left of the formula bar:
That’s it! Now you can just click the button to run the Analytics Edge macro!
New for v8.2: Now you can refresh all queries and macros simply by naming the button “RefreshAll”!
Updated for v8.2.