MS Excel Returning a

[SheaOliver]

Your Workflow URL

https://connect.pabbly.com/workflow/mapping/IjU3NjUwNTZkMDYzNTA0MzU1MjZmNTUzNjUxMzci_pc

Your Task History ID

IjU3NjUwNTY1MDYzMDA0MzQ1MjZlNTUzMDUxMzU1MTZhNTQzNDBmMzYi_pc

Consent to Access & Modify

I authorize Pabbly Support to log in to my account and make changes to the specified workflow for troubleshooting.

Hello,

My connection to MS Excel has begun returning an invalidOperation error. https://share.zight.com/OAue7OWe

I have several workflows using MS Excel, and have not had this issue before. I reconnected MS Excel, and the error continued.

Help!

Cheers!
Shea

 

[karilynae]

Mine is doing the same thing!

Microsoft Excel connector is no longer returning table column metadata.
File and worksheet are detected, but column list is empty after reconnecting.
Previously working workflow now fails with:
400 InvalidOperation – This operation is not permitted for the current object
No spreadsheet or workflow changes were made.

 

[Preeti Paryani]

Hello @SheaOliver,

Thanks for reaching out and sharing the details.

The MS Excel invalidOperation error you faced seems to be a temporary issue. We cloned your existing Excel step and executed it by clicking the Save & Send Test Request button, and it worked fine on our end.

Additionally, the failed task history also got completed successfully after re-execution.
Task History ID: IjU3NjUwNTY1MDYzMDA0MzQ1MjZlNTUzMDUxMzU1MTZhNTQzNDBmMzYi_pc

Please note: Since the task was re-executed, you will see two rows added in your Excel sheet (as the same data got pushed again during re-execution).

Let us know if you face the issue again, and we will assist you further.

 

[Preeti Paryani]

Hello @karilynae,

Could you please share your workflow URL so we can review the setup and assist you further?

Also, please follow this forum thread to set up your Microsoft Excel action correctly:
https://forum.pabbly.com/threads/st...ccess-the-workbooks-in-microsoft-excel.28957/

 

[karilynae]

Hello @karilynae,

Could you please share your workflow URL so we can review the setup and assist you further?

Also, please follow this forum thread to set up your Microsoft Excel action correctly:
https://forum.pabbly.com/threads/st...ccess-the-workbooks-in-microsoft-excel.28957/

Mine is working again now. I didn't need to change anything. Just re-executed the excel step in my workflow and now it went through fine with no errors. Thank you.

 

[ArshilAhmad]

Thank you for the update. We are glad the issue is fixed now.

Thanks & Regards,
Arshil Ahmad
Customer Support Associate
Pabbly.com
Rate your support