Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Accessing cube functions (ie cubevalue) from VBA | Excel Worksheet Functions | |||
CUBEVALUE Function - Excel 2007 | Excel Worksheet Functions |