Returns the result of an MDX query as an array. This is a CSE/Array formula so must be entered into a range at once using Ctrl+Shift+Enter.

This is the fastest way to return cube results into Excel, but limits your options for altering the query. Query Generators can help ease of use and allow users to filter the report based on Dimension Slicers and cell values.


XL3GridArrayLookup( Connection, Mdx, [MemberHandling] )


Parameter Description
Connection Connection number to use
Mdx The query to run. Typically from a cell so that the query can be updated.
MemberHandling Optional, how to output members
0/Missing Members not displayed
1 Member unique names
2 Member captions


Here we have our MDX statement in cell A1. We select the range we want to output the results to, and type

Then press Ctrl+Shift+Enter.


Note that any cells outside of the data area return #N/A

See Also