How to install the Jet Reports add-in in Excel (step by step)

A clean step-by-step Jet Reports install for Excel, and the fix for the most common problem afterwards — when the Jet ribbon doesn't appear. Includes the definitive check that the add-in has actually loaded.

Independent guide · 2026-07-20

Installing Jet Reports takes a few minutes. The reason it has a reputation for being fiddly is a single failure mode: the install completes, you open Excel, and the Jet ribbon isn't there.

Before you start

Have your connection details to hand — the Business Central web service URL and credentials, or the SQL server and database for on-premises NAV/GP — and close Excel completely. The installer cannot patch a running Excel.

A note on 32-bit vs 64-bit. Jet installs into C:\Program Files (x86)\ regardless, so you cannot tell which build you have from the folder. If you want to check your Excel, it is File → Account → About Excel — but don't use the install path as evidence either way. We'll show you a far more reliable check below.

The install

Flowchart: check Excel bitness, close Excel, run the matching Jet installer, add the data source, then test. If the Jet ribbon does not appear, check COM Add-ins, then Disabled Items, then reinstall matching the bitness.Installing Jet Reports — and fixing the missing ribbon1. Check Excel bitnessFile - Account - About Excel2. Close Excel fullyinstaller cannot patch a running Excel3. Run matching installer32-bit Jet for 32-bit Excel4. Add data sourceJet ribbon - Data Source Settings5. Test with NL()confirm data comes backJet ribbon didn't appear?File - Options - Add-insset Manage to COM Add-ins, tick JetStill missing? Disabled Itemsselect Jet, Enable, restart ExcelStill missing? Bitness mismatchuninstall, reinstall matching ExcelBitness mismatch is the usual culpritRibbon loads but no data? That is a connection problem, not an install one.
  • Download the installer from your insightsoftware account, or the link your partner provided.
  • Run it and choose Jet Reports (the Excel add-in).
  • Open Excel. You should see a Jet Reports tab on the ribbon.
  • Click Data Source Settings and add your ERP connection.
  • Test with the Report Wizard, or a simple =NL("Rows","Customer","No."), to confirm data comes back.

A successful install looks like this — a Jet Reports tab with the full toolset:

Excel tab strip showing File, Home, Insert and the other standard tabs with a Jet Reports tab at the end, circled.
What success looks like: a Jet Reports tab sitting alongside Excel's own tabs.

The Jet ribbon didn't appear

This is the common one. Work through these in order; stop as soon as the ribbon returns.

1. Check it isn't simply unticked

Go to File → Options → Add-ins. At the bottom, set Manage to COM Add-ins and click Go. If Jet is listed but unticked, tick it:

Excel COM Add-ins dialog with Jet Reports ticked, showing Location JetReports.xll and Load Behavior Loaded.
Tick Jet Reports here. The Load Behavior line underneath is the definitive check — it should read Loaded.
This dialog is the reliable test. Load Behavior: Loaded means the add-in is genuinely running — no guesswork about versions or bitness. If it says anything else, that is your problem. Note the file is JetReports.xll: Jet is an XLL add-in, which is why it doesn't always appear where you'd expect in Excel's settings.

2. Check Disabled Items

In the same Manage dropdown, choose Disabled Items and click Go. If Jet appears there, select it, click Enable, then restart Excel. Excel moves add-ins here automatically after an unexpected shutdown, and they stay until manually re-enabled.

3. Bitness mismatch

If Jet appears in neither list, the installed build may not match your Excel. A 32-bit add-in will not load into 64-bit Excel or vice versa. Uninstall Jet, check File → Account → About Excel, and reinstall the matching build.

This is genuinely the last thing to check, not the first — the COM Add-ins dialog above will usually have told you the answer already.

Ribbon appears but no data? That's a connection problem, not an install one — and it usually surfaces as "provider cannot be found". We cover that separately in our provider error guide.

Frequently asked

How do I know for certain the add-in loaded?
File → Options → Add-ins → Manage: COM Add-ins → Go. If Load Behavior reads 'Loaded', it is running. That is the only check that needs no interpretation.
Do I need admin rights?
Usually yes for the installation itself. The data-source configuration afterwards is per-user and doesn't require admin.
The ribbon disappears every time Excel crashes.
Excel is moving it to Disabled Items. Re-enable it as above; if it recurs frequently, the underlying crash is worth investigating rather than the add-in.
Does Jet Reports work in Excel for Mac or Excel on the web?
No. It is a Windows desktop Excel add-in, so it needs Excel for Windows.
Installed, but reporting still isn't working?
That's usually setup, not software. A free review will tell you which.

Book a free reporting review
Related guides

← All guides