SAP Knowledge Base Article - Preview

2836036 - IBP Excel Add-in: How to lock cell edit-ability via Formatting Sheet while using Multiple Time Levels


You want to lock cell edit-ability via Formatting Sheet but it only works when a single time level is selected. If you select multiple time levels (e.g. Technical Week and Month), the formatting/locking is gone.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.



  • SAP Supply Chain Management (SCM)
  • SAP Sales and Operations Planning (SCM-SOP)
  • SAP Integrated Business Planning (SCM-IBP)


SAP Integrated Business Planning for Supply Chain all versions


IBP, add in, lock, cell, edit, EPM, formatting, multiple, time, levels, axis, locking, sheet , KBA , SCM-IBP-XLS-UI , Frontend , SCM-IBP-XLS , Excel Client , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.