Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Activation Error - Excel Cannot Access .xlam


Moderate - requires installation permissions and access to the MS Office installation media

Overview

An error can occur when activating the Jet Excel add-in if Visual Basic for Applications is not installed with Excel.  If you attempt to automatically activate the Jet Excel add-in, you may receive a message like the following that suggests that you try to manually activate:

Error1.jpg

If you then attempt to manually activate the add-in, you may receive an error like the following that explains that Excel cannot access the .xlam file:

Error2.jpg


Resolution Process

Install Visual Basic for Applications for Microsoft Excel and retry the activation for the Jet Excel add-in.

Please read all instructions before proceeding

  1. Start the Windows Control Panel

    vba01.png

    Click Programs and Features

    vba02.jpg

  2. Browse to and select Microsoft Office and click Change.

     vba03.png

    You may need to insert your Microsoft Office CD at this point.
  3. Select Add or Remove Features and click Continue.

    vba04.png
  4. When choosing Installation Options, expand Office Shared Features, click Visual Basic for Applications, and select Run from My Computer.

    vba05.png
  5. Click Continue and then Close

    You are now ready to retry the activation of the Jet Excel add-in

     

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments