When a user is trying to access the OLAP cubes in Excel by using Jet Reports, the following error message is displayed:
Excerpt text from the error message:
An unexpected error has occurred: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=22.214.171.124, Culture=neutral, PublicKeyToken89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
This is caused by the required ADOMD.NET client not being installed. The client is normally installed automatically during the installation of the Jet Excel add-in but, if this error comes up, the installation was blocked and the client must be installed manually.
Download and install the correct version of the ADOMD.NET client from the Microsoft Download link below on the client machine.