Using PowerAutomate to Open an Excel File, Calculate, and Save

Anonymous
2021-10-19T18:31:40.84+00:00

Say i have a folder that has several excel reports in it. Instead of having to go into each report every week... is there a way for PowerAutomate to trigger every Monday morning to open each excel file, hit the 'Calculate Now' button, and then Save the file in the same folder. Even if it just overwrites the same name that is OK, but i'd be interested in having it save the file with the date at the end ("Report72_10.19.21")

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,773 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426K Reputation points MVP
    2021-10-19T18:39:14.883+00:00

    Power automate is not currently supported here on Q&A. The product group for Power automate actively monitors questions in dedicated forums here.
    https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

    --please don't forget to upvote and Accept as answer if the reply is helpful--

    0 comments