I have created a Pivot table which has an External datasource OLAP
cube( created by 'create offline OLAP cube wizard' by Excel from MS
Access database ).
I distribute my report comprising of An Excel workbook and olap cube
vy zipping the two files together.
When the other users unzip the file to see the report the Pivot asks
for the datasource again which they have to locate and then save.Is
there any way where can I define the path of the datasource same as
the path of the workbook?

When I create a Pivot table from OLAP cube once I click any page field
for the first time I get an error message "The Operation connects to
an external data source'
How can I suppress this warning message?