This is the order that range-driven members are resolved in:

  • If the range is in another grid, the member is resolved from that grid.
  • If the Get unique names from formula ranges is set for the workbook and the range contains an XL3Member formula, use that member.
  • If the text is blank use the default member for the hierarchy.
  • If the text starts with Mdx: then use those custom members.
  • If the member is an XL3Calc* formula, then use that custom member.
  • If the text is an alias, use that member.
  • Otherwise, the member is resolved by asking the data source for a member with the cell's text as its caption.