PC Review


Reply
Thread Tools Rate Thread

Pivot table from olap cube Warning and datasource

 
 
Tewari
Guest
Posts: n/a
 
      28th Mar 2007
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?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
suppress warning and locate cube in a pivot table from olap cube Tewari Microsoft Excel Misc 0 28th Mar 2007 07:54 AM
Message from Pivot having OLAP cube as datasource Tewari Microsoft Excel Discussion 0 26th Mar 2007 06:13 PM
Pivot table and OLAP Cube Edvin Sovinc Microsoft Excel Programming 0 20th Nov 2006 05:16 PM
Pivot Table - OLAP Cube =?Utf-8?B?ZGxpbnZmYw==?= Microsoft Excel Misc 0 31st Jan 2006 01:26 AM
olap cube (pivot table) =?Utf-8?B?Sm9kZWw=?= Microsoft Excel Programming 0 15th Dec 2004 12:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:56 AM.