Spreadsheet Server Ribbon

Recalculates all formulas in the worksheet. Click the drop-down list to access additional functions (for example, recalculate formulas for a workbook, worksheet, or selection, etc.)

Opens the Local Cache or Global Cache panel, listing cached records (see View or Refresh Local Cache or View or Refresh Global Cache for more information). Click the drop-down list to access additional functions (for example, view cache records, clear the cache, recalculate, clear buffer, etc.).

Clears and rebuilds memory of all stored items.

Generates detailed reports for all GXE and GEXD formulas in the workbook (see Expand to Account Balances, Expand to Journals, and GEXD Formula for more information) . Click the drop-down list to access additional functions (for example, all or selected GXEs or GEXDs, account detail reports (see Generate Account Detail for Current Sheet for more information), etc.

Based on the formula in the current active cell and the default action assigned to the Drill Downdown arrow in the user's Spreadsheet Server Settings:

• 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).

Click the drop-down list to access additional functions (for example, drill down to panel or worksheet options (see Drill Down to Journals per Account(s) and Drill Down to Selected Ad Hoc for more information).

Opens the Summary Drill Down (see Drill Down to Summarized Account Balances for more information) and related summary drill down options.

Expands the balances for the selected GXL formulas on a row into account details (see Expand or Collapse Row for a GXL Formula for my information).  Click the drop-down list to access additional functions (for example, expand row, expand row by segment, or expand all rows).

Removes the expanded account detail rows in the selection (see Expand or Collapse Row for a GXL Formula for more information). Click the drop-down list to access additional functions (for example, collapse a row or all rows in the worksheet or workbook).

Hides any row on the worksheet containing GXL and/or GEXQ formulas in which the net result is zero for all cells (see Hide Rows with Zero Balances for more information). Click the drop-down list to access additional functions (for example, hide zero rows in the worksheet or workbook).

Displays previously-hidden rows in the workbook (see Hide Rows with Zero Balances for more information). Click the drop-down list to access additional functions (for example, restore hidden zero rows in the worksheet or workbook).

Opens the Formula Builder panel, allowing users to quickly create a template in a worksheet (see Build a Template with Formula Builder and Build a Template for Queries for more information) and to maintain parameters for a formula (see Create or Maintain GL Formulas and Create or Maintain Segment Lists for more information).

Opens the Query Designer application, allowing users to design, maintain, and run queries.

Click the drop-down list to access shortcuts which open the Select Item panel with the values returned from the specified query, allowing users to select values to be returned to the spreadsheet (see Execute Lookup without a GEXS Formula for more information).

Click the drop-down list to access shortcuts to favorite SAP T-Codes or queries, allowing users to select a SAP T-Code and the desired execution variant, or, to select a SAP T-Code or query and enter the parameters in the Query pane (see Execute SAP T-Code without a GEXD Formula and Execute Query without a GEXD Formula for more information).

Note: The shortcuts available are based on the user's licensed features, the Available on Ribbon option setting for queries, the assignment of T-Codes in Application Configurator, and the pinning of T-Codes to the SAP Ledger Specifics Settings panel.

Opens the Convert Spreadsheet Server Formulas panel, allowing users to convert all Spreadsheet Server formulas (for example, GXL, GXD, GEXQ, GEX, etc.) to values for the current sheet or workbook.

Opens the Custom Layouts panel, displaying all custom layouts in the workbook and allowing users to remove layouts (see Custom Layout Editor for more information).

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).

Corrects all broken links to the XLL in the workbook.

For Oracle ledgers only, identifies the default responsibility for GXL formulas, unless the value is overridden in the formula. This value is set when an Oracle Default Responsibility is selected during sign on (see Oracle Sign On for more information). Click the displayed responsibility name to change the value.

Opens the Upgrade Workbook Options panel, allowing users to convert various legacy Spreadsheet Server and EDASH formulas in a workbook to revised Spreadsheet Server formulas.

Disconnects all open connections for Spreadsheet Server and queries.

Opens the Spreadsheet Server Settings panel, allowing users to define various criteria to control processing and access the Log Viewer, or the online user manual (see Spreadsheet Server Settings for more information).

Displays the current status. Click to toggle, or click the drop-down list to access individual Enable and Disable options (see Sign on for more information).

Opens the Log Viewer panel, where users may view, filter, or copy log entries, and email or clear the log file (see View Log for more information). Click drop-down list to access additional functions (for example, view log, clear log, or turn enhanced logging on or off).