Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Accessing cube functions (ie cubevalue) from VBA Jose B. Excel Worksheet Functions 0 September 27th 07 08:02 AM
CUBEVALUE Function - Excel 2007 Kresimir Zoric Excel Worksheet Functions 0 June 29th 06 06:11 PM


All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"