SAP Knowledge Base Article - Public

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


SAP Cloud for Customer core applications 2105