Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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:

compile_err.png

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.

Please see the article Essentials becomes unusable after installing Office updates for more information.

  1. Disable the Jet add-in either:
  • through the Start/Windows Button --> Start | Jet Reports | Disable Jet add-in

    disable.png

  • or following the steps for Manually Enabling / Disabling the Jet Excel add-in
  • Ensure that no Excel processes are currently running (Check the Processes tab of the Windows Task Manager )
  • Uninstall Jet  from the Programs and Features section in the Windows Control Panel
  • Reinstall the Jet add-in by right-clicking the Jet setup file and selecting Run as Administrator , even if you are currently logged in as an Administrator.
  • 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.

    Published:

    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:

    compile_err.png

    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.

    Please see the article Essentials becomes unusable after installing Office updates for more information.

    1. Disable the Jet add-in either:
    • through the Start/Windows Button --> Start | Jet Reports | Disable Jet add-in

      disable.png

    • or following the steps for Manually Enabling / Disabling the Jet Excel add-in
  • Ensure that no Excel processes are currently running (Check the Processes tab of the Windows Task Manager )
  • Uninstall Jet  from the Programs and Features section in the Windows Control Panel
  • Reinstall the Jet add-in by right-clicking the Jet setup file and selecting Run as Administrator , even if you are currently logged in as an Administrator.
  • 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.

    For an optimal Community experience, Please view on Desktop