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:
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:
Install Visual Basic for Applications for Microsoft Excel and retry the activation for the Jet Excel add-in.
Please read all instructions before proceeding
Start the Windows Control Panel
Click Programs and Features
Browse to and select Microsoft Office and click Change.You may need to insert your Microsoft Office CD at this point.
Select Add or Remove Features and click Continue.
When choosing Installation Options, expand Office Shared Features, click Visual Basic for Applications, and select Run from My Computer.
Click Continue and then Close
You are now ready to retry the activation of the Jet Excel add-in