Unanswered

Write from PAD to excel adds "@" to formula.

(0) Share

Report

Posted on by WoutDW

I use Power automate desktop to write this formula to an excel worksheet "=MAX((A:A<>"")*(ROW(A:A)))" This formula returns the value of the last filled line in column A which in my testcase is 25.

When i manually enter this formula it does indeed return the value 25.

When Power automate does this excel turns the formula above into "=MAX((@A:A<>"")*(@ROW(A:A)))". Those "@" symbols are added by excel and excel claims it does not change the outcome of the formula but in my case this version returns the value 1.

I don't know how to fix this either stopping excel from adding the "@" or fixing the formula so it does work correctly with the "@" are both viable options for me.

Thanks in advance!

Wout

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Sort by

OkanMTL 703 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

This problem occured also in the past.

You could use the Send Keys activitty (after focusing on a cell).

Also I'm Curious. What is your native Excel Language? I've read somewhere that Excel for some reason tries to put @ before formulas if Excel language is not in English.

Was this reply helpful? Yes No
AdyG 50 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

For anyone looking for the solution, I have recently posted the same here:

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Adding-a-quot-quot-in-formula-while-using-Write-to-excel/m-p/2823042/highlight/true#M42859

Thanks.

Was this reply helpful? Yes No