Enable or disable the Jet Excel add-in
Beginner
Overview
You should configure Excel for the Jet tab to appear on the Excel sheet. If many users share a workstation or server, each user must configure Excel so that the Jet tab appears on the Excel sheet, as Excel remembers add-in configurations based on user.
If you open Excel with the Jet add-in by double-clicking the "Jet Reports" icon on your desktop, the Jet add-in is automatically enabled before Excel starts.
If the Jet tab is not visible when you open Excel, following are the ways to enable the Jet add-in:
Using the Enable Jet Add-In app
Manually enabling the Jet Excel Add-In
Using the Enable Jet Add-In
-
If you are a user with administrative privileges, use the Enable Jet Add-In app. This app runs automatically after you install Jet or it can be run from the Windows start menu.
Manually Enabling the Jet Excel add-in
If the Enable Jet Add-In app does not work, you can also use Excel to enable the Jet add-in manually.
-
Open Excel and go to the Excel add-ins
- Excel 2010 and higher - File > Options > Add-Ins > Manage > Excel Add-ins > Go
- Excel 2007 - Office Button > Excel > Options > Add-Ins > Manage > Excel Add-ins > Go
The Add-ins window is displayed.
-
On the Add-ins window, select the Browse... button.
If you have other add-ins enabled in Excel, it is recommended to temporarily disable them prior to enabling the Jet add-in.
-
Go to the Jet Reports folder (default: C:\Program Files (x86)\JetReports).
Select the JetReports.xll file and select OK. If you are prompted to replace the file, select Yes.
-
A Jet ribbon will be visible in Excel.
Manually Disabling the Jet Excel add-in
-
Open Excel and go to the following path based on your Excel version:
- Excel 2010 and higher - File > Options > Add-Ins > Manage > Excel Add-ins > Go
- Excel 2007 - Office Button > Excel > Options > Add-Ins > Manage > Excel Add-ins > Go
The Add-ins window is displayed.
-
Clear the Jet Reports box and select OK.