The script can be found here
Deploying an updated Office installation has always been an annoyance of mine. It is ideal to be able to deploy a fully updated Office installation so you don’t have to run a software update scan and then wait for all the office patches to download and install. Having to install less software updates can reduce your deployment or build and capture times significantly.
Side Note – To avoid all of this legacy overhead, use Office 365 Click to Run edition. It is easier to deploy and manage the click to run editions of Office because there is built in functionality to keep your installation source up to date without having to identify, download and test each individual update.
Fred has joined Now Micro and is passionate about PowerShell and how it can make life so much easier. The solution laid out below can reduce your deployment time and complexity around deploying and managing Office.
The Updates Folder
To install Microsoft Office software updates as part of the Office suite deployment you can download the applicable updates and place them in the updates folder of the Office source installation. These are in the form of MSP files. This is a well-documented process that hasn’t changed for a while.
The biggest challenge with this has always been locating all the available updates for your particular Office installation. Sifting through the windows update catalog is a real chore and I am lazy, so I looked to enlist the help of ConfigMgr and PowerShell.
In the site settings for your software update point be sure that you have selected the Office 2016 product. Do this and then synchronize your software updates point if you haven’t already.
Download all Office 2016 Software Updates, that are not expired, not superseded and for the appropriate architecture (32 or 64 bit) to a new Software Updates Deployment Package. Filter your search results to just include the architecture you are looking for. (64-bit or 32-bit)
Select all updates (ctrl-a), right click and select Download.
Create a new Deployment Package when prompted. Take note of the Package Source folder. It will be referenced later.
This will download all the source files to wherever you specified when you created the Software Updates Deployment Package. A unique directory (sometimes more than one) is created for each software update in the Deployment Package.
Remove the problematic updates –
Remove the following updates from your Deployment Package before proceeding. These updates for reasons unknown will fail to install during the deployment and will cause the installation to return a failure error code. These can be removed directly from the Deployment Package using the ConfigMgr console. (Right click each update and select delete)
Each folder created during the software update download will have a .cab file that contains the Office update MSP you are interested in. If you start extracting these archives you will quickly notice that all the software updates for Excel are named the same. This behavior is the same for all products in the suite. (Word, OneNote, etc.). PowerShell to the rescue!
This script will extract the MSP files from each cab archive, save them with a unique name, copy them to the updates folder of the Office installation and then clean up . To use this script modify the parameters of the Get-Office2016MSPsFromCab function to match your environment or specify them explicitly when running the function.
The script in its entirety can be found here.
I hope you find this useful! Contact me at @FredBainbridge with specific questions.