Thread: Cubevalue
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJ PJ is offline
external usenet poster
 
Posts: 112
Default Cubevalue

I have couple of users with various Excel 2007 spreadsheets that use the
cubevalue function.

eg. The following 2 formulas are in column D. Note the relative reference
$A129 & $A130

a. CUBEVALUE($A$4,$B$3,$A$6,$A129,D$7).
b. CUBEVALUE($A$4,$B$3,$A$6,$A130,D$7).

Intermittently, when they open the spreadsheet and "re-calculate" or
"refresh all" the values in some of the cells (eg. a above) using the
cubevalue functions are invisible while values in other cells using the same
formula but referring to other members (eg. b above) in the same cube
dimension are visible.

Please note that the base data is not changing in this scenario.

Has anyone seen this issue?

PJ