Planning with Integrated Excel 

Prerequisites

To be able to use Microsoft Excel as your planning screen, you need to make the following settings in Customizing in the definition of your planner profiles. For more information, see Setting Up Integrated Excel.

Procedure

1. Enter planning using a planner profile and choose a planning layout for which integrated Excel has been activated.

2. To open Microsoft Excel in the R/3 system window, choose Goto ® Overview screen . (It is not possible to create planning data in the period screen.)

- If you have used Customizing just to set the indicator for integrated Excel and no special formatting has been made in the Excel template for this planning layout, the system displays the planning data unformatted in the upper left-hand corner of the spreadsheet.

- If an Excel template has been formatted in Customizing, the system opens this template in Excel.

3. Enter your planning data.

Note the following:

- You must avoid any use of the following Excel functions:
- Delete
- Paste
- Sort
Use of the above functions prevents data from being imported correctly into the R/3 system.

- If you want to delete data, choose Edit ® Delete in the R/3 menu.

- Enter new objects for planning directly beneath the existing R/3 data (where appropriate, beneath the totals row). To paste, use the R/3 input help function. Note that the system does not recognize data that is separated from the existing R/3 planning data by an empty row.

- You can sort additional data into existing data by choosing Edit ® Sort in the R/3 menu.

- If the Excel spreadsheet is protected, then the entries that can be made in the individual cells corresponds to those specified in R/3.

- You can access R/3 input help by choosing a pushbutton in R/3.

- The R/3 System only imports data from the first spreadsheet in an Excel folder. You can perform additional calculations or add diagrams on an second spreadsheet. These calculations and diagrams are only kept during your planning session if they have not already been created in Customizing.

- When you enter formulas in the R/3 data area in Excel, they are overwritten by the formula result during posting, and the formulas themselves are then discarded.

- If you want to save, use an R/3 planning function or run a validity check, you need to make sure that no cell is currently being processed by Excel. You can control this by displaying the "Formula Bar" in Excel (choose View ® Formula bar).

- To run a validity check for the data you have entered, choose Confirm.

4. To post data, choose Plan data ® Post.

You then return to the initial screen.