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:
Product Categories: 15
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