•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to share Office Scripts?
Our take
Sharing Office Scripts efficiently can streamline workflows and enhance collaboration. To ensure your scripts run seamlessly across all documents, store them in a dedicated folder on your colleagues' OneDrive. While sending .osts files for import might seem straightforward, the lack of an import button can complicate the process. Instead, consider guiding your team through the Automate feature to access scripts more easily. By simplifying the sharing process, you can empower your colleagues to utilize these tools effectively without the frustration of tedious navigation.
Hi guys,
I've created a few Office Scripts for my company and want to share them with my colleagues. Here's what I'm trying to achieve:
- The scripts should run in any document (not tied to a specific workbook) and appear in the Automate gallery.
- Users should store the scripts in a folder on their own OneDrive. I tested putting the scripts on SharePoint, but every user gets annoying warnings then when running the script.
ChatGPT says I can just send the .osts files to my colleagues and they should be able to import them, but I don’t see any import button (neither in the desktop app nor the web version).
The only method that worked for a colleague was:
Automate → New Script (creates a useless file) → All Scripts → Show More Scripts → My Files → browse through a huge list of folders to find the right one → add the file.
Repeat for each script.
Is there a less terrible way to do this?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- What are your favorite Office Scripts that you use often or saves you the most amount of time?I often use VBA and LAMBDA functions to speed up my work. My favorite VBA script, which I use a lot, is one that lets me append worksheets from another workbook into my active workbook. However, because of Excel Online and security concerns, things are shifting toward Office Scripts. Some VBA scripts I couldn't migrate (like the one above), but others worked. For example, one I use regularly is an Office Script that consolidates the worksheets of my workbook into a single worksheet: (I am not allowed to post this here as square brackets are forbidden) I'm curious how many of you use Office Scripts and what you've built with them to save time. submitted by /u/ExoWire [link] [comments]
- How to follow the wiki guide for sharing scripts without breaking my post rulesI am trying to share an Office Script with my team through a SharePoint folder instead of my personal OneDrive. I read through the submission rules and the wiki page on sharingquestions but I am still confused. Do I need to paste the full script code into my post body or just link to the file. I want to make sure I follow the posting guidelines correctly. Also if I store the Excel file and the script in the same SharePoint site will that let my coworkers run the script without triggering a permissions error. I have been testing this for two days and keep getting stuck. submitted by /u/carlosfelipe123 [link] [comments]
- 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 submitted by /u/MR_Datenanalyse [link] [comments]
- Personal account Automate not workingHello all, Several months ago I typed some .osts scripts to run against data in Excel. They worked fine and ran. They are stored in my OneDrive Documents/Office Scripts folder and always have been. It is a personal 365 account, so I realize the feature is in Preview. Recently I opened Excel and it could not find most of my scripts. When I click the folder button on the one I can see that used to take me to the folder where they were stored, a window pops up that says Bad Request with a url containing cdnstorage.public.onecdn.static.microsoft. I can make a new script from excel but it does not appear in the onedrive folder when I do that now. I restarted my PC, logged in and out of One Drive, used PC manager to clean all my temp files, I am at a loss. Has anyone experienced this before? submitted by /u/Few-Willingness2703 [link] [comments]
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#Excel compatibility#financial modeling with spreadsheets#no-code spreadsheet solutions#Excel alternatives#Office Scripts#Automate gallery#OneDrive#SharePoint#import#.osts files#scripts#folder#desktop app#web version#New Script#All Scripts