Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I refresh 2 pivot tables from same OLAP cube Peter Bebbington Excel Discussion (Misc queries) 0 April 28th 08 09:21 AM
OLAP Data Cube Hood Excel Worksheet Functions 0 August 21st 07 04:16 PM
suppress warning and locate cube in a pivot table from olap cube Tewari Excel Discussion (Misc queries) 0 March 28th 07 06:54 AM
Pivot Table - OLAP Cube dlinvfc Excel Discussion (Misc queries) 0 January 31st 06 12:26 AM
Will an OLAP cube or Pivot Table (or something else) solve my prob Crimsonkng Excel Discussion (Misc queries) 0 May 23rd 05 09:14 PM


All times are GMT +1. The time now is 11:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"