Make .dotx, .xltx, .potx templates work on Sharepoint
When you open a template (.dotx, .xltx, .potx) stored in Sharepoint library, it doesn't open a new document based on the the template like it does on a file share, but opens the template itself.
Please make it work like on file share, and open new document.
J Villa commented
This is not an idea, it's a BUG. Shame on you.
One way to get this functionality currently (but not ideally) would be to have the org's template top-level folder sync'ing via OneDrive (but sync'ing the SharePoint folder) and then you CAN set the WorkGroup Template location to your local sync'd folder.
This is pretty basic and can't understand why this has not been prioritised yet. We have lots of organisational templates/ calculation sheets that we would like to store in our intranet but we don't want the outputs to be stored in a Sharepoint library as they are stored in Project Folder in network drives.At the moment this is resulting in a horrible user experience as users have to open the files in Excel/Word app and find a way to download and save to the right location.
It seems to work fine in Chrome/Firefox or when syncing the folder but IE/Edge force it be opened in edit mode. A lot of sites suggest adding the template as a custom template but if you don't want copies of the file in sharepoint that'd just be creating another problem.
For those who stumble on this when googling for a solution, to work around it I added Link to a Document as a content type, placed the file in a folder with access restricted to view only, then created a Link to a Document outside the restricted folder that forces a download by using the format http://company.sharepoint.com/siteName/_layouts/download.aspx?SourceUrl=https://company.sharepoint.com/siteName/filepath/filename
By no means an elegant solution and I'm sure there are many better ways out there. It would be great if a work around wasn't needed in the first place.
Glenn Davis II commented
Still doesn't work. This seems like a day one thing that should work, Microsoft wants people to adopt O365 and SharePoint. I've relegated to syncing the directory to have it in Windows Explorer / OneDrive.
site content type doesnot work for Excel & powerpoint documents. We've implemented some content types in SharePoint; it works fine for word documents, but we are unable to open the document templates for Excel and PowerPoint anyway (cannot open the excel or PPT templates through any internet browser (IE, Chrome, Edge, Firefox, etc.) or unable to open such templates at the client desktops either.
Kjetil Engen commented
This needs to be implemented as soon as possible
This is a very necessary feature to get working
It does appear that is you use FireFox and not Edge or IE, and click on a XLTX file in SharePoint, that the file will not open at all in the browser but Excel will open based on the template and save as is the default with .xlsx extension. This is not the same for Edge/IE where the template opens in the client and a save will update the template, not what is expected.
Mark Stahl commented
Yes, custom templates would go a long way to making the transition from shared drives to SharePoint much easier for end-users. Seems like a feature that would have been built-in from the start. Must be a lot harder to do than we think. Thanks.