Deploying Microsoft Office with MDT

Before You Start

The modern Microsoft Office suite is now only available as a ‘Click-to-Run’ installation, which changes how the installation package is obtained, configured and deployed.

These are the resources we’ll be using in this guide.

Creating a Config File

Configuration of the Office suite is now done via an XML file. You can generate one by using the Microsoft 365 Apps admin center. Simply go to the site and click on the “Create a new configuration” button.

Under “Products and releases” choose what architecture and Office Suite you require, how often you want Office to update - I recommend the “Monthly Enterprise Channel”, and which apps to include or exclude.
For “Language” either choose specific languages or “Match Operating System”.
Under “Installation options” you should choose “Local source” and enter the “Source path” of: Z:\Applications\[Your-Office-Install] as this will be where the files are stored in MDT. Z:\ is automatically mapped to %deployroot% during an MDT Task Sequence.
For the “Update and upgrade” options this will depend on whether you plan on Office updating from the internet on the systems once it is deployed, or if you want to have a central Office update on the local network (maybe using my Office Update Utility), or if you are using Config Manager.
For the Upgrade options, these can be disabled as we will be installing office as part of a clean build of Windows.
Under “Licensing and activation” you will need to set “Automatically accept the EULA” to enabled, set any product keys if required and choose what type of activation you need.
For “General” provide your Company name and a description for this config file. I tend to use a brief list of the config choices for future reference.
Under “Application preferences” you can set any specific preferences that you require.
When you are happy with your config file, click “Export” and you will be prompted to choose the “Default File Format”. I generally choose the “Office Open XML formats”.
Finally, accept the terms in the license agreement, enter a file name and download the file.

Downloading the Office installation files

First download and extract the Office Deploy Tool (ODT) from Microsoft to a new folder. The included example XML files can be deleted.
Put your XML config file in the same folder as the Office Deploy Tool.
Make a copy of your XML config file and edit one of them.
Edit the “SourcePath” near the top of the file to point to a location on your local drive, for example: SourcePath="C:\Users\sysadmin\Downloads\ODT" and then save it.
Open a command prompt and change directory to the folder that contains the Office Deploy Tool and your config XML file.
Run the following command to download the Office files: setup.exe /download [your-edited-config.xml]
A new folder called “Office” will be created and the installation files will be stored there.

Importing the Office installation files into MDT

Copy the entire folder containing the Office Deploy Tool, your config files and the Office folder to your MDT Applications folder.
Rename the folder so it matches what you entered for the Source path when you created the config file on the Microsoft 365 Apps admin center website.
Go to the MDT Deployment Workbench and open “Applications”.
Right-click on “Applications” and click “New Application”.
Choose “Application without source files or elsewhere on the network” and click Next.
Enter an Application name and click Next.
For the “Command line:” enter the following: setup.exe /configure [your-config.xml]
For the “Working directory:” enter the following: .\Applications\[Your-Office-Install] and then click Next.
Finally on the summary screen click Next and then Finish.

After importing the installation files you will now be able to install Office as part of a Windows deployment Task Sequence like any other application.

Group Policy ADMX Files for Office

The ADMX files for Office are backwards compatible with previous versions of Office back to Office 2016 and they can be downloaded here.

Support My Work

If you would like to support me, please check out the link below.

PayPal

If you have any questions or comments please leave them below.

-Mike