Identifying the Area for Data Input/Output 
Before Interactive Excel can import data into or export data from a matrix, Interactive Excel must be able to identify the data area in the matrix. The data area in a matrix is adjacent to the column and row layout, and consists of cells relating to these layouts.
If you define a matrix in which the row and column layouts and their respective cells are unique, Interactive Excel automatically recognizes the data area.
If a layout only occupies a single row or column, it can be confused with the header data and therefore Interactive Excel cannot identify the layout as a row or column layout. In this case, you are prompted to explicitly specify the data area at the following events:
After you have saved a matrix definition that you have changed by clicking
Data Matrix 
Change 
.Click
Data Matrix Import data to fill a matrix with data.
Example
You have inserted a hierarchy of consolidation items in the row layout of a matrix and a version in the column layout. Interactive Excel cannot identify the data area because it does not recognize a layout that only contains one characteristic value.
Procedure
Select the data area by dragging the cursor over the worksheet.
Select Choose to the right of the coordinate field to confirm your entry.
Click Confirm.