Show TOC

Function documentationInteractive Excel Settings Locate this document in the navigation structure

 

You can make different formatting settings and general definitions for your work with Interactive Excel.

Features

Formats for Hierarchies

You can change the color of the individual levels and their indent level. Your settings are saved locally on your computer.

Formats for Matrix Cells

You can define different formats for the following cells:

  • Locked cells (cannot be used for data entry, for example, totals items or invalid characteristics)

  • Cells that can be used for data entry

  • Output cells in reports (into which data is imported)

These settings are applied to the entire workbook.

If you choose Change for the relevant cells, a standard Microsoft Excel dialog box opens. In this dialog box, you define the formats that you want to use.

The default format template for Interactive Excel is applied and should be sufficient for your needs. However, you can choose a different template if required.

Settings
Shortcut Key for Possible Entries

When you insert a single value or set aggregation into a cell, a possible entries function is applied to the cell. You can use the button to the right of the cell to display a list of possible values.

The default key combination for this function is STRG + h. If required, you can set a different key combination.

Only read the values manually

Interactive Excel reads changed matrix data from the SAP system by default. Choose this setting if you want to prevent data from being automatically updated, for example, if you want to create varied valuations on the basis of data from a key date.

If you activate this option, only manual update is allowed and every time you log on to Interactive Excel, a system message prompts you that the automatic update feature is deactivated.

Define Font

You can change the font of user interface texts, such as the texts displayed in Interactive Excel dialog boxes.

You can choose either a fixed-width font or a proportional font, for which further options are available. You can also display sample texts.

Global Settings

You can display and change the global parameters that you work with in the SAP system.

Default Settings

You can use the SAP defaults function to restore the standard settings for Interactive Excel.

Activities

You can make your settings by clicking   SAP Interactive Excel   Settings  .