1 min readfrom 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 ScriptsShow More ScriptsMy 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?

submitted by /u/coup_de_foudre_69
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

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