Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table accessing data from OLAP cube
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I refresh 2 pivot tables from same OLAP cube | Excel Discussion (Misc queries) | |||
OLAP Data Cube | Excel Worksheet Functions | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
Pivot Table - OLAP Cube | Excel Discussion (Misc queries) | |||
Will an OLAP cube or Pivot Table (or something else) solve my prob | Excel Discussion (Misc queries) |