Microsoft Excel Add-In

Home > Custom Add-In for Excel > Excel Add-In

Sage Intelligence Reporting Microsoft Excel Add-In

The Sage Intelligence Reporting Microsoft Excel Add-In is provided to offer extra functionality within your Sage Intelligence Reporting Reports directly from within Microsoft Excel. The Microsoft Excel Add-In currently supports the following Functions:

• Drill-Down Tool
• Hide Zero Rows Tool
• Quick Pivot
• Format Pivot
• Add Accounts
• About Report Tools

Note: If Microsoft Excel has been re-installed then the Sage Intelligence Reporting Microsoft Excel Add-In may not be available in Microsoft Excel.

To rectify this make sure that Microsoft Excel is closed and run the PLMAINT.EXE tool in your Sage Intelligence Reporting [Metadata Server] folder on each Sage Intelligence Reporting client workstation.

From the Tools Menu choose Register Sage Intelligence Reporting Add-Ins. This will register the Add-In with Microsoft Excel and the menu will become available in Microsoft Excel at next run. Should you register the add-in and find that the Report Tools menu is still not available on the Microsoft Excel menu bar, then using PLMAINT.EXE again, register the COM Server as well.