Compile Error in Hidden Module: XlamJetFunctions
This information applies to Jet Reports versions 2018 and earlier
Symptom
When starting Excel with the Jet Reports add-in installed, the following error is displayed:
Complete text of error message is:
Compile Error in Hidden Module: XlamJetFunctions
Cause
This error occurs when the Jet add-in is not properly registered on the machine or the current user does not have sufficient permissions to access the registered components.
Resolution
If you are using and older version of the Jet add-in with Microsoft 365 (or any version of Office that was installed using Microsoft's "Click to Run" installation method):
This is a known Excel issue which can result after a "Click to Run" update has been applied to Excel.
- Disable the Jet add-in either:
- Go to Start > Jet Reports > Disable Jet add-in
- Or following the steps for Manually Enabling / Disabling the Jet Excel add-in
It may also be necessary to enable the Jet add-in by navigating to the Jet Reports installation folder (typically: C:\Program Files (x86)\Jet Reports), right-clicking the Jet activation utility, and selecting Run as Administrator
If you have other add-ins enabled in Excel, it may be necessary to temporarily disable all other add-ins prior to enabling the Jet add-in.