3077468 - Sales Target Planning - Cells Grayed Out

When using Sales Target Planning with a huge amount of data, some cells in Excel are grayed out and cannot be edited.

SAP Cloud for Customer

The data download to the Sales Target Planning Excel is limited to “250.000”. It is not planned to change this. Very high data volume leads to memory dumps in the system backend or freezing in Excel.

Example calculation for data volume:

Account: 2,000
Product Categories: 15
Months: 10
 2000 * 15 * 10 = 300,000

The recommendation is to split this target plan, e.g. split into quarters (3 Months). This will reduce the data volume of each target plan.

gray, grey, grayed, greyed, Excell, download , KBA , LOD-CRM-SPL , Sales Planning , Problem