What is the best way to distribute an Excel sheet based on
a local cube through the enterprise?

I am creating a local cube, I am able to define a Pivot
Table report based on this cube, but as far as I can tell
the location of the cube (say c:\Cubes\testcube.cub) is
hardwired in the Excel pivot table report.

When I want to send the sheet and the cube file per email,
the recipient saves the cube locally, and consequently has
to start over creating the pivot table report, just to
specify the location of the cube.

Is there a way to do this where the recipient doesn't have
to redefine the pivot report?



tia