Pivot Table accessing data from OLAP cube

N

Neha Sachdeva

Hi,
I am creating a Pivot table using OLAP cube (in Excel 2007) on Windows
Server 2003 OS and same Pivot Table using OLAP on Windows XP. The wierd
problem i am facing is that on Windows Server 2003 OS, the moment I finish
importing the cube, it shows me a screen like "Drop Row/Column Fields here"
and on Windows XP, it simply shows the structure of Pivot table.
Secondly,on functional side, if I email this spreadsheet across (created on
Windows XP), then the other person is not able to edit/modify it, getting a
warning message "Initialization of the Data Source failed".

On the other hand, if I do the same stuff on Windows Server 2003 and send
(email) that spreadsheet across, then its working fine. It is modified by the
user.

Could anyone please help?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
No Baseline data in OLAP CUBE 0
No Baseline data in Olap Cube 0
Doughnut Chart linked with the slicer in the pivot table 0
Changing Data Source on Multiple Pivot Tables at once 1
GETPIVOTDATA from OLAP cube - grouped field 0
Sorting Cube dimension names in a Pivot Table 0

Top