The error message, “File or assembly name JetConfigWizard or one of its dependencies, was not found”, usually occurs when pressing the Add button on the Data Sources tab in the Jet Options menu.
The cause of this error message is because Excel is looking at the wrong version of the .NET Framework.
With Jet Reports 2009, use the attached configuration file that forces Excel to use v2.0.50727 of the .NET Framework instead of the one it is currently pointing to.
To install please use the following steps:
NOTE: Loading the excel.exe.config file might interfere with other Excel Add-Ins. If the excel.exe.config file causes issues, remove the file to return Excel to its original settings and consult with your other 3rd party vendor to see if a newer version of the Add-In is available.