Add Sage EIR add in for Excel sage excel intergrated reporting
The Sage Accounts add in for Excel requires 2 Add Ins to be Enabled. One is called the Sage EIR add in and the other is Sage Report Designer for 97. Even for Office 2007 the Sage Report Designer still needs to be enabled. For the add in to show and work you might need to add these Files Manually
Sage EIR add in
Go to Excel , Options , Add-In’s
Go to manage “Excel Add Ins” , Then tick “Sage EIR add in”. If this is not in the list, click on browse and search for this file. You will have to change the drop down of “File Type” from XLA Excel Addin’s to “All Files”
C:\Windows\system32\SGXLADDIN.dll
Sage Report Designer for 97
Go to Excel , Options , Add-In’s
Go to manage “Excel Add Ins” , Then tick “Sage EIR add in”. If this is not in the list, click on browse and search for XLA’s in the directory
C:\Windows\system32\
Add any XLA’s and enable them
Once these have been added and enabled you should see the Sage Report Wizard in Add In’s. One thing , if you click on Sage Account Line , ( in the add in toolbar) and go to About the version to access Sage Line 2007 Data should be 2.0.0.34. When you install a new version of Sage Accounts , this file gets upgraded to 2.0.0.39 which does not work with Sage Account 2007. So you will need to uninstall any newer versions and reinstall older versions to be able to report data in Excel