Error in Excel with connection to analysis services cube

[TDouglassAFG]

Good afternoon,

We have multiple excel spreadsheets that connect to an analysis services cube for sales reporting.  They are all linked to the same cube and were created from the same template, however I have one report that seems to consistently give this error

"The database driver does not include necessary capabilities and cannot be used with excel".

This last worked successfully a couple months ago.  Does anyone ever have this error before and recommendations on where to look?

[seecoolguy]

is this topic dead? how was this error resolved? @TDouglassAFG 

[Jimmy801]

Hello @TDouglassAFG 

do you use a connection in the workbook and the report is a Pivot table or are you using queries to read dimensions from the cube?

Jimmy