Dear all, seek advice on why my read range values are all pending even thou from excel interface the formula is showing otherwise
Hey @Teck_Hwee_Goh we can’t read the excel formula using read range it only reads the data inside cells. Forumlas cannot be read using read range activities
Regards
Sreejith S S
Hi there, yes i understand it doesnt read it as formulas but i puzzle why the values it read is not what the formula is suppose to generate. It is generating all as “pending”
Hi @Teck_Hwee_Goh ,
This does seem bit unlikely. Could you provide us with a sample file if possible.
If you are using Modern Design Read Range Activity then could you set the properties as shown below and check whether you’re able to achieve the correct result.
Anil_G
ashokkarale
Ajay_Mishra
Gautham_Pattabiraman
BHUSHAN_NAGAONKAR1
vrdabberu
ABHIMANYU_THITE1
lrtetala
samantha_shah
shyamala_shyamu