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.
ashokkarale
Yoichi
Anil_G
sudster
Kismet_Tosun
anand.t
k.sakaguchi0804
SorenB
Akash_Javalekar1
Sisay_Dinku