Skip to main content

Notifications

Power Automate - Power Automate Desktop
Suggested answer

Workflow Stopped Writing to Excel

(0) ShareShare
ReportReport
Posted on by 6
Hi Team,
I have a desktop workflow that I have been running daily for the last few months. All of a sudden, yesterday it stopped working. There is a step in the flow that writes SQL Query results to an Excel sheet. This step has stopped working. I deleted the step in the flow and re-created the step. That did not work. I then built an identical new workflow and tried to run that. It did not work either. It keeps getting hung up on the write to excel step. This flow had been working daily for several months prior. I have similar workflows on other laptops that have the same steps that are currently running and not failing. I have validated that the excel sheet it is writing to is not protected and that I am writing to column A, row 1. Is there anything I can do to get my workflow back up and running again?
Categories:
  • Nived_Nambiar Profile Picture
    Nived_Nambiar 16,665 on at
    Workflow Stopped Writing to Excel
     
    Quite strange - did you try to open the excel after flow is stopped - any thing noticed ?
     
     
  • DanielS79 Profile Picture
    DanielS79 6 on at
    Workflow Stopped Writing to Excel
    Hi,
    Thanks for your fast reply. Unfortunately, I checked everything and there was no issue with those. There is no pop-up, and the column and row indexes are within those guidelines. I also closed excel from task manager and tried to run it again, and it failed again. It opens the blank excel sheet, it just won't write to it. I am a little confused because it had been writing to it previously for the last few months, and then it just stopped. There was no update to software that I remember recently either. Do you know of anything else I can check? Again, I have that same workflow on my other laptop and it is running normally. For whatever reason, on this laptop, it just stopped being able to write to excel. Any help with this is appreciated.
    Thanks!
  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 16,665 on at
    Workflow Stopped Writing to Excel
     
    Did you check whether any popup is appearing when trying to write to excel ?
     
    Also did you check these highlighted points as well ?
     
     
     
    Else Just try to end any excel process from task manager and start the flow - see whether that helps !
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #9 Get Recognized…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,867

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,174

Leaderboard