How to enable macros in Microsoft Excel to allow payroll reports to populate correctly from Sage VIP Classic and Sage VIP Premier.
Payroll reports generated in Excel use templates that rely on macros to populate data from CSV files. You need to enable macros for these reports to work.
Change Macro Settings
- Open Microsoft Excel.
- Click File on the menu.
- Select Options.
- Click Trust Centre.
- Select Trust Centre Settings.
- Click Macro Settings.
- Choose Enable all macros.
- Click OK to apply the changes.
Running the Excel reports
When you generate any Excel report from payroll, click Enable Content when prompted.
Unlock more value with add-on modules for your payroll
Add functionality that supports operational efficiency, informed decision‑making, and long‑term growth
Leave your details and we'll be in touch.
I want to know more
- Solution ID
- 201103115237517
- Last Modified Date
- Fri Feb 20 06:33:49 UTC 2026
- Views
- 0