•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Best way to share Office Scripts?
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]
Want to read more?
Check out the full article on the original site
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