Excel Integration - on premise only

This describes the Excel Integration module which lets you analyse your accounting data and generate reports using special Sage 200 functions in Excel.

You create reports by applying special Sage 200 functions to an Excel spreadsheet. The Sage 200 functions retrieve information from the Sage 200 database and display it in an Excel spreadsheet. For example, if you want a report to display the balance of a bank account, you can apply the Sage 200 function SgAccBankBalance.

The first time you use Excel Integration in Sage 200, you must add the Sage 200 functions to your Excel application.

Once you have prepared a spreadsheet, any changes to the structure or account names in Sage 200, will affect the report.

If you are using Excel 2010 and you find that the spreadsheet values are not updating because the spreadsheet cannot find the .xla file, then within Excel 2010:

Select the Data tab.
Select Edit Links.
Choose Change Source.
Browse to the location of MMS_Excel.xla and click Open.

By default the file is stored in the ...Sage\Excel folder. If you are using Sage 200 on a network, specify the network path (as a UNC path).

Re-save the spreadsheet and it should now retain the location of the xla file.

Values for your bank accounts, nominal accounts and stock items, are reported in the base currency. Customer and Supplier account values are reported in the currency specified on the individual record.

It is not possible to use Excel Integration to import data from Excel into Sage 200.