Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Insert Members

    XL3Member formulae can be inserted directly into the spreadsheet using the XLCubed > Insert Formula > Members ribbon or menu option.

    To insert members:

    1. Select the XLCubed > Insert Formula > Members ribbon or menu option
    2. Choose a location for the new formulae
    3. Choose the connection to use from the dropdown
    4. Select the hierarchy the desired members belong to
    5. Select the members to insert. An overview of how to select members can be found here
    6. Click OK and the formulae will be inserted

    Additional Options

    • If you want to just insert the captions of the members instead of XL3Member formulae, select the Insert as Text checkbox
    • If multiple members are selected, they can be either inserted vertically (Insert down) or horizontally (Insert right)

    See Also