Answered

Error message "Failed to close Excel instance"

(0) Share

Report

Posted on by teekayjunior

I'm new to Power Automate but think the objective I'm after is fairly simple. I have a spreadsheet that tracks a running 52-week tally of closing stock prices for various securities. The spreadsheet utilizes the Stock Data Type to access this information. I would like to update the file daily even though it is viewed far less frequently. Accordingly, an automated approach is very appealling.

I set up a flow as follows:

Launch Excel
Select Tab in Window (Button "Refresh All")
Close Excel

The flow fails at that last step. I get the error message "Failed to close Excel instance." I don't know what I'm doing wrong or how to resolve the error.

Any help is greatly appreciated!

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

kinuasa 799 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

It's possible that the refresh process hasn't finished.

Why not try using the "Wait" action before closing Excel?

Was this reply helpful? Yes No
Verified answer

Deenuji_Loganathan_ 6,255 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@teekayjunior
Could you provide some screenshots of your flow with sensitive information hidden? This will allow us to better understand your issue and provide more targeted assistance.

Meanwhile, It seems that your Excel file is still in use. Consider adding wait before closing it to ensure that all operations are completed.
Thanks,
Deenuji Loganathan 👩‍💻
Automation Evangelist 🤖
Follow me on LinkedIn 👥

-------------------------------------------------------------------------------------------------------------
If I've helped solve your query, kindly mark my response as the solution ✔ and give it a thumbs up!👍 Your feedback supports future seekers 🚀

Was this reply helpful? Yes No