It works on my laptop and breaks the second anyone else uses it
operator stories
I had a workbook that did the whole week. Macros, a hidden sheet, a button I made in 2021. It was fine. Then I emailed it to Dana in the office and Dana's Excel said the macros were dead and also where is the file it is looking for on C:\Users\me.
This is a very current problem. People search "how do I share this Excel" and "it only works on my computer" and, if they built something in a weekend tool, "how do I let my coworker use this." Same shape. The laptop is the product, and the laptop does not scale to two people.
Put the data where a browser can open it
Google Sheets, or Excel in the browser, or a boring shared drive the office already has. Not because cloud is better. Because Dana does not have your add-ins, your Python, your C:\Users\me. If the work is a list, it can usually live in a sheet they already know how to sort.
I copied the values, not the macros, into a Google sheet and lost two formulas I liked. Dana could open it. I was annoyed for a day and then I was less of a bottleneck, which I pretended I did not enjoy.
Wrap it so they click a link
If it has to be a little app, they need a URL, not a zip file and a README. I have sent zip files. They do not get opened. A link they can tap from a phone in the warehouse will get used even if the UI is ugly. A cheap host, a SharePoint page, whatever you can keep running without you in the room.
If it needs your laptop on, it is not shared. It is a demonstration.
Write the six steps so they do not need your machine
Sometimes you do not need to share the tool. You need to share the job. Print the steps. Put them in the email. Download the export. Paste in column A. Run the filter on vendor. Send me the rows in red. I fought this because I had built a button. The button was for me. The office needed the steps.
The thing that works on your laptop can stay on your laptop if you are the only one who should run it. Be honest about that. The failure is when you pretend it is a system and it is a file on your desktop named FINAL_v7.
When it only works on your machine is the try here.