Skip to Content
avatar image
Former Member

Upload data from Excel to the Planning Book

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 23, 2008 at 05:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Prafulla,

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

      Regards,

      Ranjini.

  • avatar image
    Former Member
    Sep 23, 2008 at 11:36 AM

    Hi Rajini,

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

    Thukral

    Add comment
    10|10000 characters needed characters exceeded