Pivot tables in Excel with cubes as data source
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?
Windows 2000 professional
Microsoft OLE DB provider for OLAP services 8.0
Thanks in advance