Upload data from Excel to the Planning Book

[Former Member]

We are on APO 5.1. We have APO DP at the moment. I wanted to test upload of data from Excel to the planning book. I have tried several times. I have been unable to see any changed data in the planning. I do not get ANY errors during the upload. But I cannot see any changes that I made in the excel in the planning book. Please let me know what I am doing wrong. These are the step that I follow.

1. Go to planning book.

2. Short list only one key figure e.g Customer Forecast.

3. Go into Details All mode.

4. Download the file using the "Prepare File for Upload" option.

5. Open the saved Excel.

6. Change the values in the excel , save and close.

7. Upload the excel into the planning book using the upload file option.

I do not get any errors during all these steps. However, when I check to see if the values have been updated, the changes made in the excel are not updated in the planning book.

[Former Member]

Hi Rajini,

You can also do Copy paste directly into Key figure row from excel sheet.

Thukral

[Former Member]

Hello,

Instead of selecting one key figure in data view, please select all key figures of the planning book and then try all the steps which you have carried out.

please revert after you carry out this.

Regards,

Prafulla

[Former Member]

Hi Prafulla,

I have tried the same steps with all the key figures too. It does not make any difference.

Regards,

Ranjini.