Skip to Content

Excel data validation in input schedule & expansion

In my scenario, users should be allowed to choose only from a limited set of values--e.g. 10, or 20 or 30.

As shown in the following table, in the rows I have an expansion on e.g. cost centers. In the columns, I have only one member of the account dimension--e.g. labour cost.

    A                                 B                              C                           

1                                                                      LABCST (account)

CC1  (Cost Center)        Administration           Drop-down list

CC2  (Cost Center)        Production                Drop-down list

CC3  (Cost Center)        IT                             Drop-down list

I've implemented the drop-down list taking advantage of Excel's data validation functionality. I've set validation in cell C2, allowing a list of values (e.g. 10, 20, and 30), This works for cell C2 where, as a result, the user can only plan one of such values for cost center Administration.

I'd like that Excel's validation configuration gets copied also in all other cells during expansion--i.e. cells C3 and C4 in the previous example. This would result in a dynamic input schedule. Unfortunately though, validation is not copied. Only formats and values are copied. So when I choose for instance 20 in cell C2, 20 gets copied in C3 and C4. However, the drop-down list is not available in C3 and C4.

Am I missing something? If expansion does not copy validation, I'm not in a position to implement a fully dynamic template 😕

P.S. I'm on BPC NW 7.5

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jul 18, 2012 at 01:52 PM

    Hi Davide

    I don't understand.

    Is the standard behavior to expand even validation.

    I also tried on release 10 with an EVDRE and never problems on 7.5.

    It would be possible to see the input schedule?

    I think there are no special settings be made.

    Regards

    Andrea

    Add comment
    10|10000 characters needed characters exceeded