Error with step add row to table in excel

[opti-biz]

Your Task History ID

IjU3NjUwNTY5MDYzNDA0MzE1MjZjNTUzMTUxM2E1MTYxNTQzMjBmMzUi_pc

Hello,

I am using the "add row to table" action in excel, but when it executes, it throws an error "FileOpenUserUnauthorized".
When I have the workbook open in another tab, the workflow executes properly, but it should execute also when the workbook is not opened.

Here is the url: https://connect.pabbly.com/workflow/mapping/IjU3NjAwNTY0MDYzMjA0MzM1MjZhNTUzYyI_3D_pc

I also have similar observation as in post https://forum.pabbly.com/threads/i-cant-connect-with-excel.23304/ meaning that my wokrbooks are not properly listed in the dropdown; hence I have to map the workbook id directly.

I tried to reconnect in incognito mode, without success.
My workbooks are on OneDrive, personal account.

 

[Preeti Paryani]

Hello @opti-biz,

Please refer to this thread and follow the steps, and let us know if you can populate the Workbooks in Microsoft Excel.

Steps to be followed to access the Workbooks in Microsoft Excel.

Please follow the exact steps below and let us know if this helps in displaying the worksheets and workbooks in the dropdowns: Log in to OneDrive. Instead of opening the Excel file directly, search for Excel files by entering "xlsx" in the search bar. Click on the required .xlsx file to open...

forum.pabbly.com

 

[opti-biz]

Hello @opti-biz,

Please refer to this thread and follow the steps, and let us know if you can populate the Workbooks in Microsoft Excel.

Error with step add row to table in excel

Hello, I am using the "add row to table" action in excel, but when it executes, it throws an error "FileOpenUserUnauthorized". When I have the workbook open in another tab, the workflow executes properly, but it should execute also when the workbook is not opened. Here is the url...

forum.pabbly.com

hello; which thread / steps are you referring to ?

 

[Preeti Paryani]

Hello @opti-biz,

Apologies, please try access the above thread again and follow the mentioned steps.

 

[opti-biz]

@Preeti Paryani It still does not work.
I notice that the few workbooks I see listed are in fact those share with me by others; I cannot display my own... that is strange

 

[opti-biz]

@Preeti Paryani
Here is what I have done:
- in Onedrive, I have disconnected completely from another MS account (pro) that was listed there
- I have reconnected excel step in Pabbly Connect and refreshed several times

Then, more files appeared in the list, but for whatever reason, I cannot display all of them; for example, filtering on file name does not return the expected file.
I have inserted the excel file ID instead, and it now seems to work.

 

[ArshilAhmad]

Thank you for the update. We're glad to hear that the MS Excel action step is now working correctly.