Excel pivot tables from Analysis Services - Question on deployment to end users

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

.