I am connecting to a SSAS 2005 cube using Excel 2003 cube analysis. When the report is in pivot table mode then the values returned are correct when I change a dimension value such as time.month and when the sheet is recalculated then all results returned are correct.
When I convert to free- form and change the CUBECELLMEMBER for time.month the cells containing CUBECELLVALUE functions return return a null (selected in options) when I know there is a value in the cube for that cell. If I edit the cell containing the EDITCUBECELLVALUE function (F2 and enter) the correct value appears in the cell.
This occurs when connecting to a cube which has been deployed with a role of full control.