Clears cache and recalculates the formula for the selected cells in the worksheet (see View or Refresh Local Cache or View or Refresh Global Cache for more information).

Based on the formula in the current active cell:

• Opens the Drill Down panel or a worksheet displaying account balances, making up the calculated GXL amount (see Drill Down to Detailed Account Balances and Drill Down to Multi-Column Account Balances for more information).
• Opens the Drill Down panel or a worksheet, displaying detail records for the specified query (see GEXQ Formula and GEXI Formula) for more information.
• Opens the Select Item panel, displaying values for the associated query (see GEXS Formula for more information).

Allows users to select which account segments to use for grouping or summarizing accounts when displaying account balances which make up the single GXL value (see Drill Down to Summarized Account Balances for more information).

Expands the balances for GXL formulas in a row into account details (see Expand or Collapse Row for a GXL Formula for more information).

Removes the expanded account detail rows in the selected section (see Expand or Collapse Row by Segment for a GXL Formulafor more information).

Opens the List Accounts panel, listing the accounts used in the GXL formula (see List Accounts for a GXL Formula for more information), or allows users to generate a list of existing accounts.

Opens the Locate A Segment panel, displaying the valid values, @ fields or hierarchy values for each account segment.

Opens the Data Validation panel, allowing users to create a validation list for a specific cell in Excel (see Spreadsheet Server Validation for more information).

Generates detailed reports for the selected GXE formula (see Expand to Account Balances and Expand to Journals for more information).

Executes the selected GEXD formula (see GEXD Formula for more information).