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.
 

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

Pivot table report invalid 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot table hierarchical dimension expansion 0
making an excel table visible for external data on pivot table 1
Pivot table from olap cube Warning and datasource 0
Excel pivot tables and SSAS 2
persistent "invalid reference" error message 2
Accessing Cubes -- Pivot Tables vs. Cube Analysis Add-In? 1

Top