While Providing Formula in Excel facing Error

Hi,

I was trying to insert a formula in excel facing unexpected special character adding in it. Please guide me to figure this out. attached the screenshot.

after executed the code, from excel its like

image

i didt provide “@” in formula but its presented after executed the code.

@srinivasanma1

Formula cannot be used in workbook activities please use write cell in excel activities…that should solve the issue

cheers

Nope, again the same issue.

image

image

still the same

Hi @srinivasanma1

Could you please try it in manually in excel is it working?

@srinivasanma1

Can you try using modern excel activities…also please confirm your excel package version and excel version…as there was one old reported bug…

try to change the excel version higher also might help

cheers

Yeah i did it, Yes its working while checking by manually but while executed with activity its getting change

@srinivasanma1

As @Anil_G suggested could you please with Modern Excel Activities

@srinivasanma1

Please try with modern if you have access or try to upgrade excel activities to latest and check as there is a reported bug already in classic, which is not fixed as of Apr 22

cheers

Thanks to all, its working with Modern activities.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.