It is important for a company that the employees comply with the CI / CD. There are various ways of defining the standard templates in the Office applications. In this article I have put together a collection of how you can manage these Office templates per application with Intune or SharePoint.
Table of Contents
Office Standard Templates with Intune
For the standard templates, I have already written a post for each Office application. I distribute these Office templates with Intune, the general ones with SharePoint.
Program | Anleitung | Template |
---|---|---|
Word | Word Standard-Vorlage mit Intune | Normal.dotm |
Excel | Excel Standard-Vorlage mit Intune | Book.xltx / Sheet.xltx |
PowerPoint | PowerPoint Standard-Vorlage mit Intune | blank.potx |
Outlook | Outlook Standard-Vorlage mit Intune | NormalEmail.dotm + Registry |
Office template centrally on SharePoint
The standard templates may not be sufficient for you. There are also the normal templates for all Office applications. In order not to have to distribute them, but still be able to manage them centrally, there is a feature that can be activated in SharePoint.
This makes it possible to centrally manage templates for letters, documentation or logs, for example.
The template library is a normal document library on SharePoint. What is special is that the read authorization for "Everyone except external users" must be available on it.
After you have entered the library with the appropriate permissions (preferably with a few templates), you can run the PowerShell script below.
By the way, you can also create folders in the library to sort the templates.
IMPORTANT: The template files must have the file extension ".dotm", ".dotx", ".xltm", ".xltx", ".potm" or ".potx".
You have to have the PowerShell Module SharePoint module installed on your system to execute the following code.
$orgName = Read-Host 'What is your onmicrosoft.com-prefix? '
Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential
$TemplateURL = Read-Host 'What is your template library URL?'
Add-SPOOrgAssetsLibrary -LibraryUrl $TemplateURL -OrgAssetType OfficeTemplateLibrary -CdnType Private
Code language: PowerShell (powershell)
After execution, it takes a while (calculate 24 hours to be on the safe side) before the users in your organization see a new tab with the activated template under "New" in the Office applications. The template appear in Word, Excel and PowerPoint.
Hi Florian.
This looks very useful but I would like to test it on a smaller group before deploying it to an entire tenant, is there a way to do this? If I only give certain people access to the site, will only those people be affected?
Thank you for your very helpful guides!
Unfortunatly this only works for all. But it's low risk since classic templates will work side by side.
I see, thank you!
Hi Florian,
vielen Dank für deinen Beitrag?
Wie kann ich die Office Vorlagen wieder entfernen?
Reicht es aus, die Vorlagen aus der Dokumentenbibliothek zu löschen?
Gibt es keinerlei Möglichkeiten das nur auf einen kleinen Benutzerkreis zu testen?
Zum Beispiel nur Benutzern Zugriff auf die Bibliothek erteilen, bei denen es getestet werden soll?
Danke für eine kurze Rückmeldung!
Leider funktionieren diese Voreinstellungen nur "für alle oder keinen". Mit dem Befehl PowerSHell kann man den Switch aber sehr schnell wieder zurücksetzen:
Remove-SPOOrgAssetsLibrary -ListId 58454454-6546-6466-9769-646464623988