Overview
Excel needs to be configured to recognize the Jet add-in. Since Excel stores add-in configuration on a user-by-user basis, if multiple users use the same workstation or server, this step must be done for each user.
If you launch Excel with the Jet add-in by double-clicking the "Jet Reports" icon on your desktop...
...this automatically ensures that the Jet add-in is enabled before Excel is started.
Otherwise, there are a two ways to enable the Jet add-in.
- If you are a user with administrative privileges, you can use the Jet Activation Wizard. This wizard runs automatically after you install Jet or it can be run from the start menu.
- You can also use Excel to enable the Jet add-in manually
Manually Enabling the Jet Excel add-in
-
Open Excel and go to the Excel add-ins
- Excel 2010 and higher - File/Options/Add-Ins/Go
- Excel 2007 - Office Button/Excel Options/Add-Ins/Go
-
Click the Browse... button
If you have other add-ins enabled in Excel, it may be necessary to temporarily disable them prior to enabling the Jet add-in. -
Navigate to the Jet Reports folder (default: C:\Program Files (x86)\JetReports)
Select the JetReports.xlam file and click OK
If you are prompted to replace the file, select Yes:
-
A Jet ribbon should now be visible in Excel
Manually Disabling the Jet Excel add-in
-
Open Excel and go to the Excel add-ins
- Excel 2010 and higher - File/Options/Add-Ins/Go
- Excel 2007 - Office Button/Excel Options/Add-Ins/Go
-
Un-check the box next to the listing for Jet Reports...
Comments