Hello!
I use pivot tables in Excel witch uses cubes in Analysis Services as data source. In some cells I don't get any figures for the measures. What I get is "#Saknas!" (Swedish so I guess if one have an English version it would be "#Missing!". But when I look in the cube there are values in those cells.

Has anyone had this problem and knows how to solve it?

I have:
Windows 2000 professional
Excel 2000
SP-3
Microsoft OLE DB provider for OLAP services 8.0
SQL-server 2000


Thanks in advance

//Boson

Try this link
http://www.contextures.com/xlPivot04.html

I tried it but it doesn't do it!