SAP Knowledge Base Article - Preview

2699841 - IBP: Excel UI - How to edit Sheet Options without permission access to Template Admin section


To avoid individual template creation/deletion/update by planners, you restricted planners’ access to the 'Template Admin' section.

However, under Template Admin >> Advanced >> 'EPM Sheet Options' there are other options to use, i.e. 'No Data and Zero Values'.

In this case how can planners access the IBP Sheet Options and format basic things like 'No Data and Zero Values' or "Repeat Row Headers" but not add/delete/update templates?



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


SAP Integrated Business Planning all versions


Sheet options, template, admin, advanced, EPM, IBP, No Data and Zero Values, Repeat Row Headers, , KBA , SCM-IBP-XLS-UI , IBP Frontend , How To

About this page

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

Search for additional results

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