{"id":265,"date":"2022-12-29T14:06:56","date_gmt":"2022-12-29T13:06:56","guid":{"rendered":"https:\/\/blog.bardalen.no\/?p=265"},"modified":"2022-12-30T09:45:08","modified_gmt":"2022-12-30T08:45:08","slug":"library-for-office-templates-in-sharepoint","status":"publish","type":"post","link":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/","title":{"rendered":"Creating a library for Office templates in SharePoint"},"content":{"rendered":"\n

Are you moving all your file shares to SharePoint and scratching your head for what to do with all your companys Office templates? Look no further, I’ve got you covered! Not only will I explain how it all works but also provide you with some PowerShell-lines to create a document library where you can store your templates.<\/p>\n\n\n\n

How it all works in Office 365<\/h2>\n\n\n\n

Microsoft has provided a native solution for customers going full cloud and needing a centralized store for Office templates. They call it a «organization assets library» where you can store these files. You can create and specify up to 30 libraries in an organization, but all must reside in the same SharePoint site. And only libraries can be set as an asset library, not a specific folder. So be sure you create a dedicated library for this. You can also create a library for storing images and photos as well, but I’m not covering that here.<\/p>\n\n\n\n

When you assign a library for templates it creates a CDN (Content Delivery Network) in your tenant. This takes care of the distribution of the templates to the end users’ computers and is done automatically. A CDN makes sure your resources are downloaded from a server close to your clients, and providing a good performance. <\/p>\n\n\n\n

Microsoft Docs: Content Delivery Networks<\/a><\/p>\n\n\n\n

How to do it in PowerShell<\/h2>\n\n\n\n

The Microsoft way of doing it is to create a document library manually, and designate that library via PowerShell. We are here taking this a step further and and we do everything in PowerShell with the help from a module called PnP Powershell<\/a>. Follow the link to get help with installing that, or proceed to read if you already have it.<\/p>\n\n\n\n

This script is also available on my GitHub<\/a>. Feel free to add comments and suggestions if you have ways to improve it!<\/p>\n\n\n\n

First we need to connect to the SharePoint Admin site as an admin with enough priviliges to create a SharePoint site:<\/p>\n\n\n\n

PowerShell<\/span><\/path><\/path><\/svg><\/span>
Connect-PnPOnline<\/span> <\/span>-<\/span>url https:<\/span>\/\/<\/span>yourdomain-admin.sharepoint.com<\/span> <\/span>-<\/span>Interactive<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This next command creates the site, with Title, Site name, Location, Time zone and description. The «-Wait» at the end makes sure every artifact is ready before we continue:<\/p>\n\n\n\n
PowerShell<\/span><\/path><\/path><\/svg><\/span>
New-PnPSite<\/span> <\/span>-<\/span>Type TeamSite <\/span>-<\/span>Title <\/span>"<\/span>TemplateSite<\/span>"<\/span> <\/span>-<\/span>Alias <\/span>"<\/span>TemplateSite<\/span>"<\/span> <\/span>-<\/span>IsPublic <\/span>-<\/span>Lcid <\/span>1044<\/span> <\/span>-<\/span>TimeZone <\/span>4<\/span> <\/span>-<\/span>Owner <\/span>"<\/span>thatuser@yourdomain.com<\/span>"<\/span> <\/span>-<\/span>Description <\/span>"<\/span>SharePoint site for templates in Word, Excel and PowerPoint<\/span>"<\/span> <\/span>-<\/span>Wait<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
List of supported Locales<\/a><\/p>\n\n\n\n
A blank and empty site will not do, unless you want to use the default «Shared documents» library. To create a new, dedicated document library we must first change the context of where we run our commands:<\/p>\n\n\n\n
PowerShell<\/span><\/path><\/path><\/svg><\/span>
Connect-PnPOnline<\/span> <\/span>-<\/span>url https:<\/span>\/\/<\/span>yourdomain.sharepoint.com<\/span>\/<\/span>sites<\/span>\/<\/span>TemplateSite <\/span>-<\/span>Interactive<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Then we create the dedicated library:<\/p>\n\n\n\n
PowerShell<\/span><\/path><\/path><\/svg><\/span>
New-PnPList<\/span> <\/span>-<\/span>Title <\/span>"<\/span>Templates<\/span>"<\/span> <\/span>-<\/span>Template DocumentLibrary <\/span>-<\/span>Url Templates <\/span>-<\/span>EnableContentTypes <\/span>-<\/span>EnableVersioning <\/span>-<\/span>OnQuickLaunch<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
And finally, set this very Library as a Assets library in your organization:<\/p>\n\n\n\n
PowerShell<\/span><\/path><\/path><\/svg><\/span>
Add-PnpOrgAssetsLibrary<\/span> <\/span>-<\/span>LibraryUrl https:<\/span>\/\/<\/span>yourdomainn.sharepoint.com<\/span>\/<\/span>sites<\/span>\/<\/span>TemplateSite<\/span>\/<\/span>Templates <\/span>-<\/span>OrgAssetType OfficeTemplateLibrary<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
This command may throw an error saying CDN is not enabled in this organization. Ignore that message. <\/p>\n\n\n\n
Now everything is ready to copy files to the newly created library. After some time those files will appear in Word, Excel and PowerPoint as templates looking like this:<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Sources<\/h2>\n\n\n\n
https:\/\/learn.microsoft.com\/en-us\/sharepoint\/organization-assets-library<\/a><\/p>\n\n\n\n
https:\/\/pnp.github.io\/powershell\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Are you moving all your file shares to SharePoint and scratching your head for what to do with all your companys Office templates? Look no further, I’ve got you covered! Not only will I explain how it all works but also provide you with some PowerShell-lines to create a document library where you can store your templates. How it all works in Office 365 Microsoft has provided a native solution for customers going full cloud and needing a centralized store…<\/p>\n
Les mer Les mer<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,64,55],"tags":[53,5,22],"class_list":["post-265","post","type-post","status-publish","format-standard","hentry","category-microsoft-365","category-powershell","category-sharepoint","tag-microsoft-365","tag-powershell","tag-sharepoint"],"yoast_head":"\nCreating a library for Office templates in SharePoint - Blog.bardalen.no<\/title>\n<meta name=\"description\" content=\"Create a central store for your companys Office templates with PowerShell\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\" \/>\n<meta property=\"og:locale\" content=\"nb_NO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Creating a library for Office templates in SharePoint - Blog.bardalen.no\" \/>\n<meta property=\"og:description\" content=\"Create a central store for your companys Office templates with PowerShell\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog.bardalen.no\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-29T13:06:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-30T08:45:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png\" \/>\n<meta name=\"author\" content=\"Tony Bardalen\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet av\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tony Bardalen\" \/>\n\t<meta name=\"twitter:label2\" content=\"Ansl. lesetid\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\"},\"author\":{\"name\":\"Tony Bardalen\",\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a\"},\"headline\":\"Creating a library for Office templates in SharePoint\",\"datePublished\":\"2022-12-29T13:06:56+00:00\",\"dateModified\":\"2022-12-30T08:45:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\"},\"wordCount\":496,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a\"},\"image\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png\",\"keywords\":[\"Microsoft 365\",\"PowerShell\",\"SharePoint\"],\"articleSection\":[\"Microsoft 365\",\"PowerShell\",\"SharePoint\"],\"inLanguage\":\"nb-NO\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\",\"url\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\",\"name\":\"Creating a library for Office templates in SharePoint - Blog.bardalen.no\",\"isPartOf\":{\"@id\":\"https:\/\/blog.bardalen.no\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png\",\"datePublished\":\"2022-12-29T13:06:56+00:00\",\"dateModified\":\"2022-12-30T08:45:08+00:00\",\"description\":\"Create a central store for your companys Office templates with PowerShell\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#breadcrumb\"},\"inLanguage\":\"nb-NO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nb-NO\",\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage\",\"url\":\"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39.png\",\"contentUrl\":\"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39.png\",\"width\":996,\"height\":1234},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hjem\",\"item\":\"https:\/\/blog.bardalen.no\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Creating a library for Office templates in SharePoint\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.bardalen.no\/#website\",\"url\":\"https:\/\/blog.bardalen.no\/\",\"name\":\"Blog.bardalen.no\",\"description\":\"A blog about cloudy stuff\",\"publisher\":{\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.bardalen.no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nb-NO\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a\",\"name\":\"Tony Bardalen\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nb-NO\",\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/433273fdcc418ba1a5101686ae0fa85fc15baf53a2bafc63eb84bce1911caa0e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/433273fdcc418ba1a5101686ae0fa85fc15baf53a2bafc63eb84bce1911caa0e?s=96&d=mm&r=g\",\"caption\":\"Tony Bardalen\"},\"logo\":{\"@id\":\"https:\/\/blog.bardalen.no\/#\/schema\/person\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Creating a library for Office templates in SharePoint - Blog.bardalen.no","description":"Create a central store for your companys Office templates with PowerShell","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/","og_locale":"nb_NO","og_type":"article","og_title":"Creating a library for Office templates in SharePoint - Blog.bardalen.no","og_description":"Create a central store for your companys Office templates with PowerShell","og_url":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/","og_site_name":"Blog.bardalen.no","article_published_time":"2022-12-29T13:06:56+00:00","article_modified_time":"2022-12-30T08:45:08+00:00","og_image":[{"url":"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png","type":"","width":"","height":""}],"author":"Tony Bardalen","twitter_card":"summary_large_image","twitter_misc":{"Skrevet av":"Tony Bardalen","Ansl. lesetid":"4 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#article","isPartOf":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/"},"author":{"name":"Tony Bardalen","@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a"},"headline":"Creating a library for Office templates in SharePoint","datePublished":"2022-12-29T13:06:56+00:00","dateModified":"2022-12-30T08:45:08+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/"},"wordCount":496,"commentCount":0,"publisher":{"@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a"},"image":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png","keywords":["Microsoft 365","PowerShell","SharePoint"],"articleSection":["Microsoft 365","PowerShell","SharePoint"],"inLanguage":"nb-NO","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/","url":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/","name":"Creating a library for Office templates in SharePoint - Blog.bardalen.no","isPartOf":{"@id":"https:\/\/blog.bardalen.no\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage"},"image":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39-827x1024.png","datePublished":"2022-12-29T13:06:56+00:00","dateModified":"2022-12-30T08:45:08+00:00","description":"Create a central store for your companys Office templates with PowerShell","breadcrumb":{"@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#breadcrumb"},"inLanguage":"nb-NO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/"]}]},{"@type":"ImageObject","inLanguage":"nb-NO","@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#primaryimage","url":"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39.png","contentUrl":"https:\/\/blog.bardalen.no\/wp-content\/uploads\/2022\/12\/Skjermbilde-2022-12-29-kl.-13.50.39.png","width":996,"height":1234},{"@type":"BreadcrumbList","@id":"https:\/\/blog.bardalen.no\/index.php\/2022\/12\/29\/library-for-office-templates-in-sharepoint\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hjem","item":"https:\/\/blog.bardalen.no\/"},{"@type":"ListItem","position":2,"name":"Creating a library for Office templates in SharePoint"}]},{"@type":"WebSite","@id":"https:\/\/blog.bardalen.no\/#website","url":"https:\/\/blog.bardalen.no\/","name":"Blog.bardalen.no","description":"A blog about cloudy stuff","publisher":{"@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.bardalen.no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nb-NO"},{"@type":["Person","Organization"],"@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/824afefe68762a6905723a53c0f28f9a","name":"Tony Bardalen","image":{"@type":"ImageObject","inLanguage":"nb-NO","@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/433273fdcc418ba1a5101686ae0fa85fc15baf53a2bafc63eb84bce1911caa0e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/433273fdcc418ba1a5101686ae0fa85fc15baf53a2bafc63eb84bce1911caa0e?s=96&d=mm&r=g","caption":"Tony Bardalen"},"logo":{"@id":"https:\/\/blog.bardalen.no\/#\/schema\/person\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/posts\/265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/comments?post=265"}],"version-history":[{"count":16,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/posts\/265\/revisions"}],"predecessor-version":[{"id":284,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/posts\/265\/revisions\/284"}],"wp:attachment":[{"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/media?parent=265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/categories?post=265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.bardalen.no\/index.php\/wp-json\/wp\/v2\/tags?post=265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
List of supported Time Zones<\/a><\/p>\n\n\n\n