3748922 - Planning not allowed when Excel worksheet is protected - SAC Excel Add-in

• In planning mode, formatting rules are applied to a table so that non-input accounts use a ReadOnlyData format and input accounts use an Unlocked format.
• These formatting rules only activate when the Excel worksheet is protected.
• With the sheet protected, cells formatted as Unlocked appear editable, but value changes are not accepted; planning actions are blocked.
• Data cannot be processed or published.
• No specific error message is shown.

SAC Excel Add-in

1. In the Excel add-in, apply cell formatting rules so non-input accounts are ReadOnlyData and input accounts are Unlocked.
2. Turn on Excel worksheet protection to activate these rules.
3. Switch to planning mode and try to enter values in cells formatted as Unlocked.
4. Observe that editing is prevented and data cannot be processed or published.

SAC Excel Add-in does not support Excel single-cell protection. It only respects worksheet protection, and when the sheet is protected, data entry via the add-in is not supported. The cell locking must be controlled by the planning model’s locking capabilities.

Configure and use the planning model’s data locking feature to define which cells are editable.

excel add-in, worksheet protection, cell protection, cell locking, planning mode, readOnlyData, unlocked, data entry blocked, cannot publish, not supported, data locking, input readiness, protected sheet, sac excel add-in, backend locking , KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem