CUBEVALUE Function in Excel: Syntax, Examples and Free Practice
CUBEVALUE is an Excel Cube function. Returns a value from a data cube connected to an external server.
CUBEVALUE syntax
Arguments
connection: The name of the data connection to the cubemember_expression1: A text expression identifying a member in the cube (optional)
When to use CUBEVALUE
Used only when a workbook is connected to an external OLAP data cube (e.g. via SQL Server Analysis Services) — not relevant for typical spreadsheet work.
Practice CUBEVALUE online, free
Open the live Excel-style spreadsheet and try CUBEVALUE yourself. No Excel install or sign-up needed to start.
Practice CUBEVALUE now →More Cube functions
Frequently asked questions
What does the CUBEVALUE function do in Excel?
Returns a value from a data cube connected to an external server.
What is the syntax of CUBEVALUE in Excel?
The syntax is =CUBEVALUE(connection, [member_expression1], ...). connection: The name of the data connection to the cube; member_expression1: A text expression identifying a member in the cube (optional).
Where can I practice CUBEVALUE online for free?
Open the free live spreadsheet on Cellgrids and try CUBEVALUE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Cube functions · Excel case studies · Excel tutorials · Excel shortcuts