Data showing #VALUE in Excel 2007 but valid data in Excel 2003
We have an Excel 2003 sheet that
has a pivot table connecting to¬†an SSAS cube.¬†The login is a user with role based security and limitations on the dimension
levels he can see.¬† In Excel 2003 the filters show correct permissions and the pivot table works great.¬†¬†
doing the exact same thing in Excel 2007, the filters show the correct permissions but the pivot table displays #VALUE.¬† No
matter what you pull with the filters everything remains the same #VALUE.
Now the field that it is being accessed
is a calculated measure (not a calc member).¬† That being said, I can pull each piece of the calculation (a simple
subtraction of two other measures), and those measure display correctly.
We have ruled out the calculation to be
incorrect because everything works correctly in Excel 2003.¬† Is there a compatibility issue.
Also note, that
someone that has access to everything in the cube, does NOT have this problem whatsoever.
We have opened an
incident with MS and they believe its an Excel 2007 issue.¬† Any help would be appreciated.