Symptom
When downloading the upload template from the Manage Prices application, the Excel file opens with display issues that prevent proper navigation. Specifically:
- It is not possible to scroll down to reach the rows that must be filled in (e.g., row A84 in the "Condition Data" sheet).
- The sheet must be zoomed out significantly to display its full content.
- When zoomed out, the cells required for the upload become too small to distinguish or fill in correctly.
The issue persists across different computers and different tenants.
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Open the Manage Prices application.
- Click Download Template.
- Open the downloaded Excel file.
- Navigate to the "Condition Data" sheet.
- Attempt to scroll down - it is not possible to reach row (e.g., row A84) or beyond.
- Zooming out displays the full sheet, but the cells become too small to read or fill in.
Resolution
After downloading the template, apply the following step before filling it in:
Unfreeze the panes in the "Condition Data" sheet:
- Open the downloaded Excel file and navigate to the "Condition Data" sheet.
- Go to View → Freeze Panes → Unfreeze Panes.
- After unfreezing, it is possible to scroll freely through the entire sheet and access all rows, including those required for the upload (e.g., row A84).
Note: This step must be applied each time the template is downloaded, as the frozen pane configuration is embedded in the file itself.
Keywords
Manage Prices, Download Template, Condition Data, Excel, scroll, zoom, frozen panes, unfreeze, S/4HANA Cloud Public Edition, upload template, rows , KBA , SD-MD-CM-2CL , Conditions and Condition Maintenance (Public Cloud) , Problem
SAP Knowledge Base Article - Public