Insert Members

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

To insert members:

1. Select the FluenceXL > 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

• XL3Member formula reference