Read Range of Excel Formula not as the correct value

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


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.