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

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