How do you properly hand over Office Scripts or trigger Power Automate flows from Excel without relying on personal OneDrive?

Hi everyone,
I’m running into a problem and I hope someone here has experience with this.

I was asked by another department to automate one of their workflows in Excel. So far so good. I didn’t want to use VBA because our company is slowly phasing it out, so I took this as an opportunity to gain experience with Office Scripts.

The script itself is finished. It can be triggered via a button and it works as intended.
However, I realized that I don’t want the script to live in my personal OneDrive “Documents/Office Scripts” folder. I want to hand it over to the department so they can use it independently.

My idea was to create a subfolder called “Scripts” next to the Excel file and store the scripts there.
But here’s the problem: I have no idea how to reference or trigger those scripts from Excel. Excel seems to only recognize scripts stored in the personal Documents folder. Even if I manually place the script there (tested with a separate account), Excel still doesn’t detect it.

So I thought about triggering the script through Power Automate instead. Surprisingly, that works well — and PA doesn’t care where the script file is stored.
BUT now I have a new issue: How do I link the flow back to the Excel file?

Ideally, I want a button inside Excel that starts the flow. The users of this file are not technical at all, so it needs to be as simple as possible.

I couldn’t find any way to connect a button in Excel to a Power Automate flow — except by using Office Scripts again, which would put me back in the same situation where the script must be stored in my personal OneDrive… which defeats the whole purpose.

Has anyone dealt with this before?
How do you hand over Office Scripts or trigger flows in a clean, future‑proof way so everything keeps working even if you’re no longer around?

Thanks a lot for your help!

PS. This text was translated and optimized with AI