Refresh of Report Data 
You can overwrite data in a report defined using a data matrix in Interactive Excel with up-to-the-minute data from a database. You can import data into one or more reports over an interactive connection to an SAP system.
Prerequisites
You have opened an Interactive Excel workbook in which a matrix report is defined.
For information about opening a new workbook, see Opening a New Workbook with Interactive Excel.
You have logged on to an SAP system on which the Business Consolidation (SEM-BCS) or the Enterprise Controlling Consolidation (EC-CS) component is installed.
For more information about logging on, see Logging On to a System.
Features
Automatic Refresh
Whenever you change characteristics and their values in your report definition, report data is automatically refreshed. You can activate and deactivate the automatic update of data by clicking 
Data Matrix 
Refresh values automatically 
.
Note
Report data is not automatically refreshed when data in the database is modified. However, each time you log on to a database, you can specify whether you want to refresh report data.
Manual Refresh
You can import the latest database data into a matrix without changing the matrix definition. In this case, you need to trigger the refresh manually. This ensures that no unwanted changes are made to report data.
You can refresh a single matrix, a pivot table, a worksheet, or an entire workbook.
Activities
After you have changed a matrix definition, data is refreshed automatically when you press ENTER.
To refresh report data in a data matrix, click Data Matrix Import Data and select the relevant report area.
Caution
Before you refresh one of several reports on a worksheet, make sure that you select the relevant report. On the Data Matrix tab, the names of all reports on the worksheet are listed in a combobox. The currently selected report is displayed when the combobox is collapsed. You can select only one report at a time.