Hi once in a while when working on reports and opening a new excel session the Jet report ribbon does not load. So far the only way I got around this is to restart my PC then it shows up, but I was wondering if there’s an easier way to load up the Jet ribbon without the need of a restart? Any tips are greatly appreciated.
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi,
Which Excel version are you using? It sounds like Excel 2007 (perhaps on XP)?
I know that behavior from my old machine with that setup.
In my case closing all Excel instances (with task manager) was the solution.
Sometimes I had to turn off and turn on again the Jet Reports addin.
I have done it via macro (placed in the QAT):Sub JetReportEinAus() If AddIns("Jet Essentials 2012 R2 (xlam)").Installed = True Then AddIns("Jet Essentials 2012 R2 (xlam)").Installed = False MsgBox "Jet Reports deaktiviert." Else AddIns("Jet Essentials 2012 R2 (xlam)").Installed = True MsgBox "Jet Reports aktiviert." End If End Sub
Cheers
André -
Jet Reports Historic Posts I'm using Excel 2013, but how do you close and re-open the add-in without shutting down the PC?
-
Jet Reports Historic Posts Try this:
1. Open Excel, go to File -> Options -> Add-Ins.
2. At the bottom, make sure "Excel Add-Ins" is selected and click the Go button.
3. Uncheck "Jet Essentials 2013" if it is checked and click OK.
4. Close Excel.
5. Repeat steps 1 and 2.
6. Click the Browse button and browse to "C:\Program Files (x86)\JetReports".
7. Select the file JetReports.xlam and click the Open button.
8. If prompted, select Yes to overwrite.
9. Click OK.
Now the Jet add-in should be there in Excel. Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.