Good evening! (ow my, it is already dark outside)
Hereby a batch script that I have running on a good batch of devices on a weekly base.
While this one should technically also work on separate Office 2016 and Office 2019 installations, I have so far only extensively tested on installations of Office365 installations.
What does the script do? Well, it is quite easy.
Office has a registry key that determines at what rate it receives updates and which updates it receives.
First thing the script does is check whether this registry exists. If it does not exist, it will stop the script and not do anything at all.
If it does exist it will follow some steps. First it will set the URL of the key to one that provides the monthly update schedule. Why monthly you ask? Because the other options have a few quirks and downsides and knowing Microsoft, we have had a good few issues when some Microsoft products had newer versions than others and it started conflicting.
(If you want to read more on the different update channels and how the updating all works click HERE)
After that it deleted registry keys that confirm version numbers, update lists etc. etc.
Why? Because while the channel has changed, a few other registries remember information gained from the old channel and these are the ones being purged.
To fix it all up again the script needs to start the update process which will cause Office to set up the connection to the new channel and if available receive new updates, therefor the last lines will start the update command for the Office applications.
What will users on the devices that it is being run on notice?
Well, if their Office does not find updates, all they will get is a message that their Office is fully up to date.
If it does find updates it will install those on the background and then ask the user to close down all Office-applications to finish up the updating.
While there are many ways to spread this script, i myself run it weekly on all workstations in the remote monitoring software we have running at the customers.
This means more updated Office365 applications (Setting it to the normal monthly will also avoid "beta/early updates" getting through. We don't want to update it TO far), which means fewer issues with other Microsoft applications or web versions like Sharepoint which means happier customers.
Hoping I will be of use to some people dealing with customers and their outdated self-managed Office-applications out there.
Categories: Script, CMD, Office, Windows
Patrick Berger AKA Powershellder.
[ i ] Parallax section below. Click on the section below to upload image. Don't worry if it looks weird in the Weebly editor. It'll look normal on your published site.
To edit or delete your image, press the "toggle" button below. Then, hover over your image until a popup appears with the "edit" and "delete" options. If you don't want a white content section, leave it blank. It will disappear on your live website.