Error Excel file access writing formula

(0) Share

Report

Posted on by Sormick

566

I need to write this formula:

=COUNTA(UNIQUE(FILTER(A5:A1000000,A5:A1000000<>"")))

to an Excel file into Range "A3"

but a get this error message "Cannot access file......"

If write a simple Text instead of this formula i don't have this issue.

Could you help me please?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

Sort by

CU31080729-3 502 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I am trying to your formula in to my flow, but i am not get any kind of error as you mention
please some screenshot of error and your flow its better to understand exact error

(Note:- if you got your solution you can mark as solution and gives kudos)

Thanks & Regards
Chetan Ninghot

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @Chetan_Ninghot
Sorry for my late reply.
Please find here the screenshot of the error (Sorry, the error is in french)
The translation of the error is: "Cannot write into Excel file"

Was this reply helpful? Yes No
CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Sormick

Have you tried assigning formula in clipboard and pasted in excel cell?

For quicker reference:
Instead of ‘write to Excel’

Set to clipboard text %Formula%
Then activate the cell you want to paste in
Then Paste cells to Excel

Here is mine, and it worked. Ignore the 'Replace Text', we use commas instead of semi-colons.

Please refer the below link - https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Is-it-possible-to-use-power-automate-desktop-to-paste-a-formula/td-p/1441404n

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(0)

Report
Copy link

Link copied!

Dear @Deenuji
What do you mean with "Set to clipboard text %Formula%" ?
I'm sorry i'm still a novice in power automate desktop.
Could you please explain a little more how to convert clipboard text to formula?

Was this reply helpful? Yes No
Verified answer

CU16071609-1 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Sormick

Please follow the below approach:
Launch Excel
Set the variable ForumlaText to the formula =COUNTA(UNIQUE(FILTER(A5:A1000000,A5:A1000000<>""))).
Set the clipboard text to the value of the variable ForumlaText.
Activate cell H1 in the Excel instance.
Paste the content from the clipboard into the activated cell in the Excel instance.
Sample flow screenshot:

Source code:

Excel.LaunchExcel.LaunchUnderExistingProcess Visible: True Instance=> ExcelInstance SET ForumlaText TO $'''=COUNTA(UNIQUE(FILTER(A5:A1000000,A5:A1000000<>\"\")))''' Clipboard.SetText Text: ForumlaText Excel.ActivateCellInExcel.ActivateCell Instance: ExcelInstance Column: $'''H''' Row: 1 Excel.PasteCellsToExcel.Paste Instance: ExcelInstance

How to copy/paste the above code into your power automate desktop?

Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No
Sormick 566 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi,

Now i know what was going wrong with my formula.
It should be translated to English formula instead of French formula on power Automate Desktop.
Now it works!
Thank you al for your support!

Was this reply helpful? Yes No