Invalid Pivot Table Message

S

Suresh Kumar

I created a cube (under Analysis Server Windows 2000) with some date fields
and processed
it. Everthing went fine.

I then created an Excel (XP) spread sheet and did 'Import External Data' /
'New database query' / 'OLAY Cubes' / to my cube.

I saved the spreadsheet and sent it to my co-worker.
When he opened the spreadsheet on his PC it opened fine; but when he double
clicked on a year column to expand, he got a message
'Invalid Pivot table'.

What am I doing wrong?

Thanks,
S.Kumar

P.S. I posted a similar message in the sqlserver.olap forum but there was no
reply. Hence I am trying my luck here with the same message.
 
Top