Jun 13 2021 06:02 PM
We have created a team in Ms Teams whose primary purpose is to hold MS Office document type templates mainly Excel & Word. So, there is a channel in MS Teams where we upload the various templates (xltx, dotx files). We then use SharePoint to create hyperlinks to those files. This allows us to create applications where you can click on a hyperlink to access the template. It all works well except for one thing - when you click on the Sharepoint hyperlink it opens the template. I am having difficulty working out how to arrange it so that when you click on the link it spawns a new document. That is we want to replicate the same functionality as it would if you opened a template on your desktop. To access a template you first must open say Excel and then from within Excel open the document. So, I guess the issue is when you click on the hyperlink, SharePoint is creating a scenario where it assumes you have opened Excel already and therefore takes you into the template. For obvious reasons this is not what we want because it will result in users corrupting the xltx, dotx files.
Mar 18 2022 08:14 AM
Jun 09 2022 08:47 AM
I created an organization asset library for templates a couple of years ago and it works great.
Create an organization assets library - SharePoint in Microsoft 365 | Microsoft Docs
Jun 09 2022 10:23 AM
Jun 10 2022 12:35 AM
@Andrew667 thanks for reply
Jul 12 2022 11:54 PM
Jul 27 2022 07:36 PM
Here's how I fixed it!
1) Create the template, and save it to a folder in SharePoint that your Team has access to.
(For this example I am using "OneDrive-Contoso/CorpTeam/SalesChannel/Templates/"
2) For each type of template, open that desktop app, click "File, Options, Save, then "Default personal templates location", then paste in ""OneDrive-Contoso/CorpTeam/SalesChannel/Templates/"
3) Now when you create a new file in that app, you'll see a Templates folder - click it, and you will see all the files, as will all your team members.
Sep 17 2022 06:41 PM
I am having a similar problem trying to insert a hyperlink to my template. The hyperlink opens the original template, not a copy. My project is for my small buisness. Not sharing with anyone or web based. All files are on my laptop. I have a desktop short cut that I normally use to begin creating a new Customer File from my template and wanted to insert a hyperlink with-in another file so I could start a new Customer File with-out having to minimize other apps to access my desk top. Ughhh!!!
Sep 20 2022 08:23 AM
@FRANK_OF_iOWA
You can't open a template from outside any of the apps, otherwise you're always opening the template itself... It needs to be triggered from the "New Document" interface within the apps themselves
Feb 13 2023 08:58 AM