SAP Knowledge Base Article - Preview

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


The sympton and resolution discussed here is valid up to IBP Add-in 2002 version.

From 2005 add-in version onward, the EPM Sheet Options have been removed and IBP Settings => Options menu have been developed! 

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?

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


Sheet options, template, admin, advanced, EPM, IBP, No Data and Zero Values, Repeat Row Headers, , KBA , SCM-IBP-XLS-UI , 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 for Me (Login required).

Search for additional results

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