Page 1 of 1

TM1 - excel validation list

Posted: Thu Jun 24, 2010 5:02 pm
by sfnicole
Hi,
I have used the validation list in the input template. It works fine when select the data from the list and the value will be saved in TM1.

However, when we choose a blank value from the list, the formula (DBRW...) is gone.

How to deselect a value from the list without loosing the formula?

Thanks in advance.

Re: TM1 - excel validation list

Posted: Thu Jun 24, 2010 10:12 pm
by paulsimon
Hi

If you are writing to a numeric cell, try putting 0 in your list instead of blank

Regards


Paul

Re: TM1 - excel validation list

Posted: Mon Jun 28, 2010 3:45 am
by sfnicole
Hi Paul,
Instead of putting zero, i put " " and it works. Thanks.