Repair office and ensure that all components of Office are installed
Overview
ExcelReportLink requires Microsoft Excel and most components of office to be installed. If the VBA or Programmatic components of office are not installed, it can cause issues when the software starts.
How to identify that VBA is not fully installed
To identify that VBA is not fully installed, follow these steps.
- Start Excel
- Go to File \ Options
- Select customize ribbon
- Tick the Developer ribbon
- Click ok to close the options dialogue
- Select the Developer tab
- Confirm that the Microsoft Visual Basic and Macros buttons are both greyed out.
If the Microsoft Visual Basic and Macros buttons are both greyed out, that is a an indication that VBA was not installed as part of Office. You will need to repair office and ensure all components get installed.
If the previous solutions do not help resolve the problem, it may be worth considering reinstalling Microsoft Office. Please contact your IT Support provider.