cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Failed to open Excel document '(Excel launching error.)'.

Last Night It was working Fine, Today I haven't changed any settings and don't know why it not working.
Failed to open Excel document '(Excel launching error.)' . -  Subflow: Main, Action: 1, Action name: Launch ExcelFailed to open Excel document '(Excel launching error.)' . - Subflow: Main, Action: 1, Action name: Launch Excel

 

DetailsDetailsError Message:- 
Microsoft.Flow.RPA.Desktop.Robin.SDK.ActionException: Failed to open Excel document '(Excel launching error.)' . ---> System.ArgumentNullException: Value cannot be null.
Parameter name: type
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.ExcelActions.LaunchExcel(Variant documentPath, Variant varPassword, Variant& excelInstance, Int32 launchMode, Boolean visible, Boolean loadAddInsAndMacros, Boolean needsAuthentication, Boolean readOnly)
--- End of inner exception stack trace ---
at Microsoft.Flow.RPA.Desktop.Modules.Excel.Actions.LaunchExcel.Execute(ActionContext context)
at Microsoft.Flow.RPA.Desktop.Robin.Engine.Execution.ActionRunner.Run(IActionStatement statement, Dictionary`2 inputArguments, Dictionary`2 outputArguments)

1 ACCEPTED SOLUTION

Accepted Solutions

Finally, I got the Solution. This Works for me, I hope it works for you too.
🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆

Step 1:- Use "Run Application" Action As shown in the Images below.
Solution for Excel Error In Power Automate DesktopSolution for Excel Error In Power Automate Desktop

 

The Problem:-  WPS Software was asking for Make it default setting for opening all office files and power automate was unable to handle it. so when the application opened I clicked on "Don't ask me again" and now its's working. Maybe your software is asking for any permission, or update. so check it ones. Hopefully, I have explained it well.

Don't forget to try other basic solutions like
1. Restart PC
2. Repairing Both Software(Office and Power Automate). Repair by offline and online Both.
3. Check if your PC OS and software are updated.

4. Try to "End Task" all excel processes in Task Manager before starting power automate.


Thank you everyone for helping me 😊.

---------------------------------------------------

Edit On 1-July-2022

Reinstalling Software always works. Also, try to uninstall the software entirely because sometimes software keeps a few files(like cache, obsolete files, logs) on your PC.

 

Before uninstalling any software make sure to save your document files somewhere safe. You can also create a restore point in windows and Backup your files in external storage to be extra safe😊.

 

View solution in original post

16 REPLIES 16

Go to Task Manager, find any Excel, right click and End Task.  Make sure they are all gone.  Then try to rerun.

----
If my post has answered your question, please thumbs up and mark this post as a solution.

I also offer paid consulting services at www.peakdigitran.com/appointments and you can find me on LinkedIn at https://www.linkedin.com/in/michael-annis-80903/,

I tried closing all excel tasks. Also, I restarted the laptop, Still Not Working. 

mgrachii
Resolver II
Resolver II

Do you have installed the most recent version of Power Automate for DEsktop?

Checked Sir, It's Updated.

Even I have reinstalled Power Automate and WPS software.

 

Do anyone, have any other suggestion?

Finally, I got the Solution. This Works for me, I hope it works for you too.
🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆🎆

Step 1:- Use "Run Application" Action As shown in the Images below.
Solution for Excel Error In Power Automate DesktopSolution for Excel Error In Power Automate Desktop

 

The Problem:-  WPS Software was asking for Make it default setting for opening all office files and power automate was unable to handle it. so when the application opened I clicked on "Don't ask me again" and now its's working. Maybe your software is asking for any permission, or update. so check it ones. Hopefully, I have explained it well.

Don't forget to try other basic solutions like
1. Restart PC
2. Repairing Both Software(Office and Power Automate). Repair by offline and online Both.
3. Check if your PC OS and software are updated.

4. Try to "End Task" all excel processes in Task Manager before starting power automate.


Thank you everyone for helping me 😊.

---------------------------------------------------

Edit On 1-July-2022

Reinstalling Software always works. Also, try to uninstall the software entirely because sometimes software keeps a few files(like cache, obsolete files, logs) on your PC.

 

Before uninstalling any software make sure to save your document files somewhere safe. You can also create a restore point in windows and Backup your files in external storage to be extra safe😊.

 

Yes, pls.

It's always better to work with updated software than outdated.

jhaskamp
Frequent Visitor

For me this was due to the variable of the path being in a list so I had to set excel to open a file with name of %Excel_File_Path[0]%

Been having the same issue since i updated PAD @HarshChauhan  did restarting work, i have restarted multiple times and i use a "terminate process EXCEL" before and after opening excel but i still get an error

I got the exact same thing since i updated PAD yesterday. Very strange and frustrating..

mtassara
Frequent Visitor

I had a similar problem.  The flow run ok in some PCs but failed in others.  I updated the flow software to the newest version and that solved the problem!

 

Adlen
New Member

I too tried all the possible solutions and apparently, the cause for this error is hidden.

Trigger: If you see an issue with Win 32 in the error message.

Cause: When Windows is updated it creates a text file named 'Program' in the C drive. This apparently occurs only in the updates of 2022 onwards.

Solution: All you need to do is delete that text file. ugh...  Follow this link to get more details: https://stackoverflow.com/questions/50970449/error-800700c1-in-instantiating-an-object-for-microsoft...

That's odd, because I updated the flow software to the newest version and it caused my problem.

@phuft - curious if you ever figured out the issue - I too have had the issue randomly appear after running a PAD flow for 9-months with no error - the only change was the PAD updates. Very frustrating!

phuft
Regular Visitor

This happened multiple times to me, and I tried all the steps mentioned above, starting with uninstalling and reinstalling the web extension for Edge. (It is confusing because the newest version of the extension icon is always greyed out, so I'm not sure if it is actually on.)

The first time I was able to find that text file mentioned in Adlen's post, and that worked.

The second time I reinstalled the extension, then in the flow I copied the offending step, deleted the original step, and pasted it back in in the same spot. (That is my goto for fixing steps that break for no reason, and it often works.)

The third time I reinstalled the extension and then restarted the machine and that seemed to do the trick. 

Unfortunately, there is no rhyme nor reason that I can see, other than that the updates seem to cause the problem.

@phuft appreciate your response - FYI - My issue was some Update was causing ONE DRIVE Sync to "keep the file OPEN". So I moved the file to users\publilc directory (instead of the ODB location) and now having NO ISSUE! 

Helpful resources

Announcements

Community will be READ ONLY July 16th, 5p PDT -July 22nd

Dear Community Members,   We'd like to let you know of an upcoming change to the community platform: starting July 16th, the platform will transition to a READ ONLY mode until July 22nd.   During this period, members will not be able to Kudo, Comment, or Reply to any posts.   On July 22nd, please be on the lookout for a message sent to the email address registered on your community profile. This email is crucial as it will contain your unique code and link to register for the new platform encompassing all of the communities.   What to Expect in the New Community: A more unified experience where all products, including Power Apps, Power Automate, Copilot Studio, and Power Pages, will be accessible from one community.Community Blogs that you can syndicate and link to for automatic updates. We appreciate your understanding and cooperation during this transition. Stay tuned for the exciting new features and a seamless community experience ahead!

Summer of Solutions | Week 4 Results | Winners will be posted on July 24th

We are excited to announce the Summer of Solutions Challenge!    This challenge is kicking off on Monday, June 17th and will run for (4) weeks.  The challenge is open to all Power Platform (Power Apps, Power Automate, Copilot Studio & Power Pages) community members. We invite you to participate in a quest to provide solutions to as many questions as you can. Answers can be provided in all the communities.    Entry Period: This Challenge will consist of four weekly Entry Periods as follows (each an “Entry Period”)   - 12:00 a.m. PT on June 17, 2024 – 11:59 p.m. PT on June 23, 2024 - 12:00 a.m. PT on June 24, 2024 – 11:59 p.m. PT on June 30, 2024 - 12:00 a.m. PT on July 1, 2024 – 11:59 p.m. PT on July 7, 2024 - 12:00 a.m. PT on July 8, 2024 – 11:59 p.m. PT on July 14, 2024   Entries will be eligible for the Entry Period in which they are received and will not carryover to subsequent weekly entry periods.  You must enter into each weekly Entry Period separately.   How to Enter: We invite you to participate in a quest to provide "Accepted Solutions" to as many questions as you can. Answers can be provided in all the communities. Users must provide a solution which can be an “Accepted Solution” in the Forums in all of the communities and there are no limits to the number of “Accepted Solutions” that a member can provide for entries in this challenge, but each entry must be substantially unique and different.    Winner Selection and Prizes: At the end of each week, we will list the top ten (10) Community users which will consist of: 5 Community Members & 5 Super Users and they will advance to the final drawing. We will post each week in the News & Announcements the top 10 Solution providers.  At the end of the challenge, we will add all of the top 10 weekly names and enter them into a random drawing.  Then we will randomly select ten (10) winners (5 Community Members & 5 Super Users) from among all eligible entrants received across all weekly Entry Periods to receive the prize listed below. If a winner declines, we will draw again at random for the next winner.  A user will only be able to win once overall. If they are drawn multiple times, another user will be drawn at random.  Individuals will be contacted before the announcement with the opportunity to claim or deny the prize.  Once all of the winners have been notified, we will post in the News & Announcements of each community with the list of winners.   Each winner will receive one (1) Pass to the Power Platform Conference in Las Vegas, Sep. 18-20, 2024 ($1800 value). NOTE: Prize is for conference attendance only and any other costs such as airfare, lodging, transportation, and food are the sole responsibility of the winner. Tickets are not transferable to any other party or to next year’s event.   ** PLEASE SEE THE ATTACHED RULES for this CHALLENGE**   Week 1 Results: Congratulations to the Week 1 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge.   Community MembersNumber SolutionsSuper UsersNumber Solutions Deenuji 9 @NathanAlvares24  17 @Anil_g  7 @ManishSolanki  13 @eetuRobo  5 @David_MA  10 @VishnuReddy1997  5 @SpongYe  9JhonatanOB19932 (tie) @Nived_Nambiar  8 @maltie  2 (tie)   @PA-Noob  2 (tie)   @LukeMcG  2 (tie)   @tgut03  2 (tie)       Week 2 Results: Congratulations to the Week 2 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 2: Community MembersSolutionsSuper UsersSolutionsPower Automate  @Deenuji  12@ManishSolanki 19 @Anil_g  10 @NathanAlvares24  17 @VishnuReddy1997  6 @Expiscornovus  10 @Tjan  5 @Nived_Nambiar  10 @eetuRobo  3 @SudeepGhatakNZ 8     Week 3 Results: Congratulations to the Week 3 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 3:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji32ManishSolanki55VishnuReddy199724NathanAlvares2444Anil_g22SudeepGhatakNZ40eetuRobo18Nived_Nambiar28Tjan8David_MA22   Week 4 Results: Congratulations to the Week 4 qualifiers, you are being entered in the random drawing that will take place at the end of the challenge. Week 4:Community MembersSolutionsSuper UsersSolutionsPower Automate Deenuji11FLMike31Sayan11ManishSolanki16VishnuReddy199710creativeopinion14Akshansh-Sharma3SudeepGhatakNZ7claudiovc2CFernandes5 misc2Nived_Nambiar5 Usernametwice232rzaneti5 eetuRobo2   Anil_g2   SharonS2  

Check Out | 2024 Release Wave 2 Plans for Microsoft Dynamics 365 and Microsoft Power Platform

On July 16, 2024, we published the 2024 release wave 2 plans for Microsoft Dynamics 365 and Microsoft Power Platform. These plans are a compilation of the new capabilities planned to be released between October 2024 to March 2025. This release introduces a wealth of new features designed to enhance customer understanding and improve overall user experience, showcasing our dedication to driving digital transformation for our customers and partners.    The upcoming wave is centered around utilizing advanced AI and Microsoft Copilot technologies to enhance user productivity and streamline operations across diverse business applications. These enhancements include intelligent automation, AI-powered insights, and immersive user experiences that are designed to break down barriers between data, insights, and individuals. Watch a summary of the release highlights.    Discover the latest features that empower organizations to operate more efficiently and adaptively. From AI-driven sales insights and customer service enhancements to predictive analytics in supply chain management and autonomous financial processes, the new capabilities enable businesses to proactively address challenges and capitalize on opportunities.    

Updates to Transitions in the Power Platform Communities

We're embarking on a journey to enhance your experience by transitioning to a new community platform. Our team has been diligently working to create a fresh community site, leveraging the very Dynamics 365 and Power Platform tools our community advocates for.  We started this journey with transitioning Copilot Studio forums and blogs in June. The move marks the beginning of a new chapter, and we're eager for you to be a part of it. The rest of the Power Platform product sites will be moving over this summer.   Stay tuned for more updates as we get closer to the launch. We can't wait to welcome you to our new community space, designed with you in mind. Let's connect, learn, and grow together.   Here's to new beginnings and endless possibilities!   If you have any questions, observations or concerns throughout this process please go to https://aka.ms/PPCommSupport.   To stay up to date on the latest details of this migration and other important Community updates subscribe to our News and Announcements forums: Copilot Studio, Power Apps, Power Automate, Power Pages

Users online (1,507)