Write Cell Error when inserting formula in Excel

Help Studio
, ,
1

Hello Guys,

I am trying to write cell using this formula:
=IFERROR(VLOOKUP(@Q:Q,‘C:\Users\uie77553\Documents\UiPath\Power BI QM\Plant Strategy[PEG export.xlsx]Sheet1’!$I:$J,2,FALSE),“”)

but i receive an error, it says that:-

Write Cell: The write operation failed, because one of the following reasons:
► The data you want to write “=IFERROR(VLOOKUP(@Q:Q,‘C:\Users\uie77553\Documents\UiPath\Power BI QM\Plant Strategy[PEG export.xlsx]Sheet1’!$I:$J,2,FALSE),”)" has a wrong format;
► Excel is busy or you are currently editing a cell;
► If your data is a formula, make sure you use comma as parameters separator;
► During the write operation make sure no dialog windows are opened.

Can you guys help me to solve this error?

I am using the formula in the excel. i dont face any problem.

2

I am not able to recreate your issue even with wrong format of formula. UiPath write the wrong formula successfully but excel get into recovery mode for file when we try to view the content.

Try to write your formula with 4 double quotes like below.
"=IFERROR(VLOOKUP(@Q:Q,'C:\Users\uie77553\Documents\UiPath\Power BI QM\Plant Strategy[PEG export.xlsx]Sheet1'!$I:$J,2,FALSE),"""")"
image