Deploying Word, Excel and PowerPoint templates for Microsoft Office 2016
In many shops, Mac admins have a requirement to deploy templates for Microsoft Word, Excel or PowerPoint. With Microsoft Office 2011, this is a relatively straightforward process as there is an existing directory for Word, PowerPoint and Excel templates at the location shown below:
/Applications/Microsoft Office 2011/Office/Media/Templates
Template files deployed to this location are available to all users on the Mac.
In contrast, the necessary support directories for templates are not created by Office 2016 by default, so they are not likely to exist unless templates had previously been installed. The reason for this is that Office 2016 apps are sandboxed and don’t have the ability to write to locations outside the application sandbox unless granted permission. Fortunately, the Office team at Microsoft has documented in the PDF document linked below where templates should be installed:
Installing User Content in Office 2016 for Mac:
When I read the documentation, it showed that the correct place to store template files is at the location shown below:
/Library/Application Support/Microsoft/Office365/User Content.localized/Templates.localized
Template files deployed to that location are available to all users on the Mac.
As mentioned previously, the necessary support directories for templates are not created automatically when Office 2016 is installed. To address this, I’ve written a script that will create the needed directory structure. For more information, see below the jump.
The script shown below is designed to do the following:
- Create the directories needed for Office 2016 Word, Excel and PowerPoint templates
- Assign those directories the following permissions:
- root: Read, Write, Execute
- admin: Read, Write, Execute
- Everyone: Read, Execute
The script is also available from my Github repo: