Enable macros in Microsoft Excel

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

  1. Open Microsoft Excel.
  2. Click File on the menu.
  3. Select Options.
  4. Click Trust Centre.
  5. Select Trust Centre Settings.
  6. Click Macro Settings.
  7. Choose Enable all macros.
  8. 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

Add more modules.

 

 

 

 

 

 

Solution Properties

Solution ID
201103115237517
Last Modified Date
Fri Feb 20 06:33:49 UTC 2026
Views
0