Compile Error in Hidden Module: XlamJetFunctions
This information applies to Reporting Intelligence versions 2018 and earlier
Symptom
When starting Excel with the Reporting Intelligence 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 Reporting Intelligence 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 Reporting Intelligence 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 Reporting Intelligence add-in either:
- Go to Start > Reporting Intelligence > Disable Reporting Intelligence add-in
- Or following the steps for Manually Enabling / Disabling the Reporting Intelligence Excel add-in
It may also be necessary to enable the Reporting Intelligence add-in by navigating to the Reporting Intelligence installation folder (typically: C:\Program Files (x86)\Reporting Intelligence), right-clicking the Reporting Intelligence 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 Reporting Intelligence add-in.