This article is for IT professionals only. Office templates are created by users. How to make common templates available to all employees (or specific groups)? This can easily be deployed using Group Policy. Here are the approaches available.
Using File Folder / SharePoint Document Library
- AD and GPMC is required.
- Put all the templates in a central shared folder or a document library.
- Install and download Group Policy admin templates for Office.
- Open Group Policy MMC, open Admin templates – MS Office <ver> – Shared Paths
- Change the setting Enterprise Templates Path
- If server share provide UNC Path.
- If SharePoint library, add that as a network location (or map as drive in login script).
- That’s It. Now users can see templates in Word, Excel, PowerPoint – File – New
Using content types
- Create a document library
- Give read only access to all users
- Create and map a content type
- Add templates to the content type
- New button in the document library will now list all mapped templates
I recently conducted a highly appreciated session at a CIO event in Mumbai. This 45 minute video is a MUST WATCH for every CIO and IT professional who is involved in effective utilization of Office and Office 365.
You can download it from HERE (46 MB WMV video).
When you click on this link, the video will try to play from OneDrive. But it WILL NOT PLAY. Click the Download button on that page, download it locally and then run it in full screen mode. If you like it, please share it with your colleagues and friends.
The recording resolution is intentionally low to keep the file size small. Some colors may show banding. But it is good enough resolution as a reference.
Do post your feedback as comments on this blog article.
In my opinion this is the worst Worst Practice. The full list is available here. Here I will discuss why phased release is bad and provide a better approach. The primary objective is to increase efficiency across the organization rapidly using the integrated Office 365 platform. Your inputs are most welcome.
Continue reading Office 365 Worst Practices – Part 2 – Phased Release: Underutilization by Design!
Office 365 is now an established and popular product. I just finished a 6 country tour where I met top 40 customers who are in various stages of deploying Office 365. I have made a list of common mistakes / wrong approaches / misaligned priorities / counterproductive behavior. Read on to ensure that you don’t repeat these mistakes. More importantly, if you have already committed the mistake, the corrective approach is also provided. This series is more relevant to CIO, IT team and the deployment teams.
Continue reading Office 365 Worst Practices – Part 1
I am amazed to see how many people don’t know this. Do you wish Insert menu had Insert Comment option?
Don’t wish. Do it.
Create new tabs or modify existing ones. Share it with your colleagues.
Powerful, useful and delightful!
Estimated reading time 5 min
Continue reading Did you know: You can change all the menus in Office?
Do you have slow performing, large Excel files? Here is the solution.
This is a simple but very important pre-requisite for analyzing large amounts of data. Although technical people are aware of this requirement, most users are not aware about this.
Let us understand the importance of 64 Bit version of Office
Continue reading Analyzing Big Data? Use 64 Bit Office