You can change the color of the individual levels and their indent level. Your settings are saved locally and are therefore computer-specific.

You can define different formats for the following cells:

• Cells that cannot be used for data entry (for example totals items or invalid characteristics)
• Cells that can be used for data entry
• Report cells into which data is imported

These settings are valid for the entire workbook.

You choose Change for the relevant cells, and a standard Excel dialog box appears. In this box, you define the formats that you want to use.

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

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 key combination STRG + h is set as default for this function, should you prefer to use the keyboard rather than the mouse. However, you can set a different key combination if desired.

Choose this setting, when you want to prevent data being automatically read from the SAP System.

Changed matrix data is normally automatically read again from the SAP-System. You can stop this, for example, when you want to create varied valuations on the basis of data from a key date, using Interactive Excel.

When you have activated this option – that means only allowing the manual update – every time you log onto Interactive Excel, you receive a system message informing you that the automatic update is deactivated.

If desired, you can change the font used for displaying the interface texts (dialogs) in Interactive Excel. Follow these steps::

1. Choose menu item SAP.

A dropdown menu appears.

2. Choose Settings.

A list of options is displayed.

3. Choose the tab Font.

Here your selected global parameters, which you work with in the SAP system, are listed and can also be changed by you interactively.

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

Make your desired settings at menu item SAP ® Settings.