Symptom
When using Sales Target Planning with a huge amount of data, some cells in Excel are grayed out and cannot be edited.
Environment
SAP Cloud for Customer
Cause
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
Resolution
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.
Keywords
gray, grey, grayed, greyed, Excell, download , KBA , LOD-CRM-SPL , Sales Planning , Problem