• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Error with step add row to table in excel

opti-biz

Member
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.

1746791799254.png
 

Preeti Paryani

Well-known member
Staff member
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.

 

opti-biz

Member
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.

hello; which thread / steps are you referring to ?
 

opti-biz

Member
@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

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

opti-biz

Member
Thank you for the update. We're glad to hear that the MS Excel action step is now working correctly.
View attachment 56396
Actually, the problem is not fixed. It even seems to be back at initial point: my files are not found (apart from those shared by others with me

Task History ID - IjU3NjUwNTY5MDYzNTA0MzQ1MjZlNTUzMjUxMzI1MTYxNTQzOTBmMzMi_pc
Executed at May 13, 2025 08:31:28, (UTC+02:00) Europe/Brussels



1747118084936.png
 

Preeti Paryani

Well-known member
Staff member
Hello @opti-biz,

Upon checking, we noticed that the error message indicates you are not authorized to access the file.

Could you please confirm whether you have the necessary access permissions to the Workbook ID mapped in the action step?

This will help us identify the cause of the issue more accurately.
 

opti-biz

Member
Hello @opti-biz,

Upon checking, we noticed that the error message indicates you are not authorized to access the file.

Could you please confirm whether you have the necessary access permissions to the Workbook ID mapped in the action step?

This will help us identify the cause of the issue more accurately.
of course
 
Top