An error can occur when activating Jet Essentials if Visual Basic for Applications is not installed with Excel. If you attempt to automatically activate Jet Reports, you may receive a message like the following that suggests that you try to manually activate:
If you then attempt to manually activate Jet Reports, you may receive an error like the following that explains that Excel cannot access the .xlam or .xla file:
Install Visual Basic for Applications for Microsoft Excel and retry activation of Jet Reports.
To install Visual Basic for Applications, go to the Control Panel and open Add or Remove Programs (Programs and Features in Windows Vista and newer). Browse to Microsoft Office and select Change.
You may need to insert your Microsoft Office CD at this point. Select Add or Remove Features and select Continue. When choosing Installation Options, expand Office Shared Features, click Visual Basic for Applications and select Run from My Computer. Select Continue and then Close.
Jet Reports could not be automatically activated for the following reason: Unable to set the Installed property of the AddIn class. Manual activation is required.