• Use our What is the compatibility of my software with Microsoft Office? guide to ensure you're using a compatible 32-bit installation of Microsoft Office
• Make sure you're using the latest version of Sage 50 Accounts. If you're not, you can download the latest software from our Install your software hub
• Check you've logged into your Sage 50 Accounts software for the required company
• Check that you have the required access rights in Sage 50 Accounts. Follow our Set up access rights, logon names and passwords for additional users article
• Ensure you're logged into Windows as an administrator
• Modify your antivirus software to work alongside Sage 50 Accounts
• Check if your Excel document is running in Compatibility mode
• Set Office Ribbon to Always display Ribbon. Also pin the Ribbon bar by pressing Ctrl + F1
• Ensure you've selected Trust access to the VBA project object model tickbox in Trust Center then Macro Settings. See the image below:

  To resolve any connection issues and error messages, you can reinstall EIR by following the below steps.

1. Close all open software then download the following file for your version of Sage Accounts. Use our Check your version number article.
   

    NOTE: To reinstall EIR with Sage 50 Accounts v27 or above, reinstall your software.

   
   
   • v26 - Excel Integrated Report (EIR) module
2. If prompted to save the file, note the file name, ExcelIntReportingInstaller.msi then click Save.
    TIP: Depending on your web browser, the file can automatically save to your Downloads folder. To view your Downloads folder, press Ctrl + J on your keyboard. 
3. Double-click ExcelIntReportingInstaller.msi. The installer runs through a progress bar, then disappears. 

If your issue persists, uninstall Excel, then uninstall Sage and then reinstall Excel and Sage and try again. If the issue persists after this, contact technical support.

 NOTE: If you receive the error 'Could not connect to data service' whilst using EIR, this is linked to Firewall settings. Ports and HIPS will need to allow the EIR tool to communicate with Sage data services. Running ESET in Interactive Mode can also help to reset your connection with EIR. Support with HIPS settings in ESET.