Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Run a Script when excel opens

We've just migrated from Google to MS365 and I'm busy translating scripts.


We had a weekly calendar excel file, a tab for each week, and the script would always make it so the active tab is the one on the current week.

Because we know people tends to click everywhere and forgets to leave it as it should.


I already have the code to do that but I cannot find how to make it run automatically whenever anyone opens that excel file.


I've already made a lot of flows that work fine, but they all come from a "on form submit", I haven't found a "when excel file opens" trigger in Flow

Dual Super User
Dual Super User

@Jordi_Support you are right there is no way to such trigger for excel in Power Automate



If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Helpful resources

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,902)