Sage X3 Support: Installing the Microsoft Excel add-in

Did you know Sage X3 has an accompanying Excel add-in that you can use to export data from grids in Sage X3 into a Microsoft Excel spreadsheet? In this blog, I will run through the steps involved in installing the add-in and using it for a simple export.

Firstly, you need to check to make sure that you are using a supported version of Microsoft Office, the latest information can be found on the prerequisite’s overview page in the client components section

Click here for the prerequisites page 

Once you have determined that you are using a supported version of office the next step is to download the installation file to deploy the Excel add-in on your workstation  

Using the Site map navigate to administration, installation, Install the add-ins for office

When you click on this menu item the add-in install file ‘SyracuseOfficeAddinsSetup.exe’ will be downloaded to the Downloads folder on your workstation

You can then launch the installation by double-clicking on the SyracuseOfficeAddinsSetup.exe’ file and the installation will start

Press Next

Press Install

If you have UAC (windows user access control) enabled, you may receive a warning like this during the installation, click yes to proceed

On the next screen press finish

The Excel add-in is now installed on your workstation; when you launch Microsoft Excel, you will see Sage as an option in the ribbon.

Now that the add-in is installed you can export data from the grids in X3 to Excel for example

Navigate to Financials > Enquiries > Balance

Enter suitable parameters and press search to retrieve data

We can now export the results in the grid to Excel by pressing the ‘Export to Excel’ option in the right menu

Alternatively, you can use the action button above the search results grid select ‘Excel export’

When you select either of these export options you will be presented with the Export Excel window, add a title/name for your export press export and then click the Excel Icon

Your export will initiate, and Excel will launch on the workstation you may see this 'protected view' message when Excel starts in that case press ‘enable editing’

You can now see your exported data in Excel and you are free to manipulate your data as needed

In certain scenarios, you may face issues installing or enabling the add-in, I recommend searching the Sage KB as it is constantly being updated with new articles that may help.

I have collated some of the KB articles from the Sage knowledgebase that may be helpful

Error: Not loaded. A runtime error occurred during the loading of the COM Add-in

Sage X3 Office Add-in does not install

Click here to download Sage X3 for Excel add-in" after already installed

Excel Add-In is not visible in Excel

Unable to export to Excel

Hope you found this walkthrough useful and gets you up and running with the Excel Add-in 

Anonymous