Summary
How to enable macros in Microsoft Excel to allow payroll reports to populate correctly from Sage VIP Classic and Sage VIP Premier.
Description
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.
Resolution
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.
