Hi,
I've created a couple of cubes in AS and some Excel spreadsheets, some with standard pivot tables and others with reports created with the Excel Add-In for Analysis Services.

The part I'm having problems with is that when I distribute the excel files, the receipients don't have the MS Query connections defined in their machines and hence they can't refresh or filter the reports.

I tried having people copy the .oqy files (for standard pivot tables) and also the .odc files (for the Excel Add-in) to their hard drives but users still can't refresh data. Could it be a credentials problem? Is there a better way to distribute the excel files without distributing the .odc and .oqy?

Thanks in advance,

Ale