cancel
Showing results for 
Search instead for 
Did you mean: 

Data Validation in the IBP Formatting Sheet (allow whole numbers X and X, otherwise error message)

vincentverheyen
Active Participant
0 Kudos

SAP note 0002987751 (2987751 - IBP Excel Add-in: How to add Data Validation on a cell from 2005 add-in version - SAP for ...) details how to add Data Validation to a cell.

Has anyone currently successfully implemented the following:

  • Allow whole numbers 9 or 10. Otherwise show error message?

using Data Validation?

I have not been able to make the same operational via IBPFormattingSheet => right click on relevant cell => Access IBP menu => Data Validation option.


This seems to have no result in the planning view.

Accepted Solutions (0)

Answers (2)

Answers (2)

Hello Vincent

Before applying validation, click on the cell next to data column and enable data validation

After this apply the condition. It should work

vincentverheyen
Active Participant
0 Kudos

Hi raghunathpartha, thank you for this answer. To complete this answer, for other readers: one must double-click on the cell on the right-hand side of the "Data" cell (= the "Use" cell).