Macros
Run workbook macros automatically after a Collect.
If your template uses VBA macros - to build a pivot, apply formatting, or run a calculation - Calc can run them for you automatically every time data is collected.
Choosing macros to auto-run
Add your macros
Build the macros you need in the workbook's VBA project as usual.
Open the Macros picker
In Design mode, click Macros. Calc lists the macros in the workbook.
Tick and save
Tick the macros that should run after Collect, and save. Your choice is stored with the template.
When they run
The ticked macros run once a Collect finishes, after the data and charts are in place - so they can act on freshly collected data.
Macros mean a .xlsm template
A workbook with macros must be saved in Excel's macro-enabled format. Calc
upgrades the template to .xlsm automatically when you save, or you can choose
it explicitly in Save As.
Last updated 17 June 2026