Unanswered

Power Automate Desktop closing excel error for Analysis for Office Excel Addin

(0) Share

Report

Posted on by Sophiegong

I try to use PAD open excel with Analysis for Office Excel Addin,then refresh the workbook .When PAD save and close this workbook, it always pop-up this error message. But when I open this workbook and refresh it manually, it will never have such error message when close this workbook.Any solution for PAD?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Sophiegong 62 on at

Like (0)

Report

Was this reply helpful? Yes No
Rhiassuring 8,690 Moderator on at

Like (1)

Report

Hi there,

This looks like an issue with the SAP Add-In. SAP recommends that you open each sheet and check the connection. Please check out this link:

https://answers.sap.com/questions/11546503/sap-bi-add-in-has-disconnected-all-data-sources-id.html

R

Was this reply helpful? Yes No
Verified answer

Sophiegong 62 on at

Like (0)

Report

Hi,Thanks for your comments for this issue.I got the solution.When I run PAD flow to refresh A4O excel file with several sheets.Even the PAD flow is complete but this "Analysis for Office Excel Addin" program is also working.So I need to put step "wait" into the flow below save and close the excel file in PAD flow.Then it will be no any error when close excel file.

Was this reply helpful? Yes No
m42 12 on at

Like (0)

Report

@Sophiegong, i am new for the Power Automate Desktop, could you share the overall tasks you added for the data extraction from the Excel SAP addin?? Much appreciate !!

Was this reply helpful? Yes No