What can you do with Office Scripts in Excel Online?

%3CLINGO-SUB%20id%3D%22lingo-sub-1791216%22%20slang%3D%22en-US%22%3EWhat%20can%20you%20do%20with%20Office%20Scripts%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1791216%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22first%22%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fplayer.vimeo.com%252Fvideo%252F462839437%253Fapp_id%253D122963%26amp%3Bdntp%3D1%26amp%3Bdisplay_name%3DVimeo%26amp%3Burl%3Dhttps%253A%252F%252Fvimeo.com%252F462839437%26amp%3Bimage%3Dhttps%253A%252F%252Fi.vimeocdn.com%252Fvideo%252F976527002_1280.jpg%26amp%3Bkey%3Db0d40caa4f094c68be7c29880b16f56e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dvimeo%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20title%3D%22Vimeo%20embed%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%20class%3D%22first%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20class%3D%22first%22%3EThis%20latest%20UX%20film%20by%20Microsoft%20Design%20showcases%20one%20of%20the%20latest%20and%20most%20exciting%20capabilities%20of%20Excel%20Online%2C%20which%20allows%20the%20recording%2C%20editing%20and%20sharing%20of%20simple%2C%20yet%20powerful%20scripts%20using%20a%20modern%20programming%20language.%3C%2FP%3E%0A%3CP%20class%3D%22first%22%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20these%20scripts%20run%20in%20the%20cloud%2C%20they%20can%20be%20scheduled%20to%20run%20autonomously%20and%20asynchronously%20across%20spreadsheets%20and%20can%20be%20associated%20with%20more%20elaborate%20automation%20workflows%20via%20PowerAutomate.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1791216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EShow%20and%20Tell%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1791861%22%20slang%3D%22en-US%22%3ERe%3A%20What%20can%20you%20do%20with%20Office%20Scripts%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1791861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%2C%20that's%20a%20nice%20video%20but%20without%20your%20explanation%20it's%20bit%20hard%20to%20understand%20what%20it's%20about.%20Perhaps%20that's%20only%20my%20impression%20since%20I'm%20more%20reading%20person%20rather%20than%20watching%20one.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1795314%22%20slang%3D%22en-US%22%3ERe%3A%20What%20can%20you%20do%20with%20Office%20Scripts%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1795314%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3EChapeau%2C%20this%20video%20is%20quite%20an%20impressive%20teaser.%20I%20counted%204%20different%20(new)%20Excel%20features%20in%20a%201%20minute%20video.%20This%20means%20to%20an%20average%20of%2015%20seconds%20per%20feature.%20Since%20I'm%20aware%20of%20the%20new%20features%20in%20Excel%2C%20I%20could%20follow%20the%20story%20in%20this%20video%2C%20but%20I'm%20afraid%20the%20average%20user%2C%20who%20has%20never%20seen%20this%20new%26nbsp%3B%20features%2C%20has%20no%20clue%20what%20is%20happening.%20IMHO%20It%20would%20be%20good%20to%20have%20links%20at%20the%20end%20of%20the%20demo%20to%20content%20pages%20that%20gives%20a%20bit%20more%20(in%20depth)%20information%20about%20the%20new%20features..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2115520%22%20slang%3D%22en-US%22%3ERe%3A%20What%20can%20you%20do%20with%20Office%20Scripts%20in%20Excel%20Online%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115520%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320924%22%20target%3D%22_blank%22%3E%40cuong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20can't%20seem%20to%20share%20my%20office%20script%20in%20my%20enterprise%20version%20of%20Excel%20on%20the%20Web.%20Per%20this%20page%3A%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fsharing-office-scripts-in-excel-for-the-web-226eddbc-3a44-4540-acfe-fccda3d1122b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EOffice%20scripts%20in%20excel%20for%20web%3C%2FA%3E%20%2C%20sharing%20scripts%20is%20not%20widely%20availabe.%20Short%20of%20contacting%20our%20Office%20system%20admin%2C%20is%20there%20an%20easy%20way%20to%20determine%20when%20this%20functionality%20has%20been%20rolled%20out%3F%20I%20did%20check%20a%20timeline%20page%20on%20Excel%2C%20but%20there%20was%20no%20mention%20of%20this%20particular%20feature.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.S.%20Can%20anyone%20recommend%20a%20more%20appropriate%20place%20for%20me%20to%20post%20my%20question%3F%20Not%20sure%20if%20this%20is%20the%20right%20forum...thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

 

This latest UX film by Microsoft Design showcases one of the latest and most exciting capabilities of Excel Online, which allows the recording, editing and sharing of simple, yet powerful scripts using a modern programming language.

 

As these scripts run in the cloud, they can be scheduled to run autonomously and asynchronously across spreadsheets and can be associated with more elaborate automation workflows via PowerAutomate.

10 Replies

@cuong , that's a nice video but without your explanation it's bit hard to understand what it's about. Perhaps that's only my impression since I'm more reading person rather than watching one.

@cuongChapeau, this video is quite an impressive teaser. I counted 4 different (new) Excel features in a 1 minute video. This means to an average of 15 seconds per feature. Since I'm aware of the new features in Excel, I could follow the story in this video, but I'm afraid the average user, who has never seen this new  features, has no clue what is happening. IMHO It would be good to have links at the end of the demo to content pages that gives a bit more (in depth) information about the new features..

@cuong 

 

I can't seem to share my office script in my enterprise version of Excel on the Web. Per this page: Office scripts in excel for web , sharing scripts is not widely availabe. Short of contacting our Office system admin, is there an easy way to determine when this functionality has been rolled out? I did check a timeline page on Excel, but there was no mention of this particular feature.

 

Thanks!

 

P.S. Can anyone recommend a more appropriate place for me to post my question? Not sure if this is the right forum...thanks!

@cuong 

It gives me the idea to use Excel on industrial automation.

But a language compiler would also be needed to connect the various modules with one another.

Excel Industry 4.0.

 

Just a thought that came up with watching this clip with me.

By the way, a nice clip :).

 

New functions are always good for me

... but this does not mean that they are also well received by users.

 

 

Nikolino

I know I don't know anything (Socrates)

@Nikolino 

What do you mean under "language compiler" ?

Convert formulas or commands into (example) PLC or CNC (machine languages).
Compilers are special translators that convert program code (in the case of Excel also formulas) from problem-oriented programming languages, so-called high-level languages, into executable machine code of a certain architecture or an intermediate code (bytecode, p-code or .NET code).

@Nikolino 

In Excel we have calculation engine for that, but why end user shall know details of how it works?

@Sergei Baklan @Nikolino Some Excel/OPC info on excel to opc - Bing if that's any help

Sharing has been rolled out to all Office Scripts users, so your admin may have disabled the option if you don't see it, unfortunately. Thank you for reaching out to us about this @namgaw - we'll make sure to get that page updated with the latest information.

In regards to whether the Excel TechCommunity is the right forum for Office Scripts questions: absolutely!! Our team is exploring places to build a more formalized "Office Scripts community" - in the mean time, feel free to post any questions you have here. In fact, we have an Office Scripts AMA (Ask Microsoft Anything) coming up next week in this space - we'd love to see you there if you're interested.

Warmly,

Nancy

Thanks, Nancy.

I'll try to make the AMA.

-James