Skip to content
Home » Excel standard template with Intune

Excel standard template with Intune

Excel standard template with Intune

Auch für Excel gibt es eine Art Standard-Vorlage, genauer gesagt zwei. Die Vorlage besteht aus einer Vorlage für neue Mappen sowie eine für neue Blätter innerhalb der Mappe. Die Vorlage für Mappen heisst «Book.xltx», während die für Blätter «Sheet.xltx» heisst. Beide können natürlich zusammen als Standard-Vorlage für Excel mit Intune verteilt werden.

For the provision, I have prepared a PowerShell script for you, which copies the two templates to the right place for the user. I use a Win32 app for distribution.
The storage path on the user side is:

C:\Users\%username%\AppData\Roaming\Microsoft\Excel\XLSTART

Table of Contents

Prepare Excel template

The "Book.xltx" and the "Sheet.xltx" are normal template files that you can prepare with Excel.

The easiest way to start is with «Book.xltx». To do this, open a new Excel folder and configure the appearance as you like. For example, you can define the font, line height and width or print title. In this file you can also predefine several sheets.
If you are happy with it, save the file as «Book.xltx».

For the "Sheet.xltx" I recommend that you duplicate the "Book.xltx" and reduce the folder to one sheet.

Copy the two created Excel template files into the package folder, which you can download from my GitHub repository. Once you have done that, you only have to generate an "Intunewin" file from the package.
I have described the process here: Create Win32 App / .intunewin

Distribute Excel template with Intune

After you have created the "Intunewin" file, all you have to do is upload it to the Endpoint Manager and assign it to your desired target group.
Add a Win32 app under «Apps > Windows apps» added.
You give this at least a name, a description and a publisher. If you also want the app to be available in the company portal, upload the icon as well.

In the program settings you have to store the execution as "User" and an installation and uninstallation command:

install command%SystemRoot%\sysnative\WindowsPowerShell\v1.0\powershell.exe -windowstyle hidden -executionpolicy bypass -command .\install.ps1
uninstall command%SystemRoot%\sysnative\WindowsPowerShell\v1.0\powershell.exe -windowstyle hidden -executionpolicy bypass -command .\uninstall.ps1
win32 program settings

The requirements in the next step are not very relevant, but must be set.

intune, win32 requirements

In the detection rule, you only have to upload the "check.ps1" included in the package.

Intune, win32 detection rule

You can skip the dependencies and supersedence.
Finally, all you have to do is assign the app to a desired target group and wait until the installation on the devices is complete.

Update Excel template

Möchtest du ein Update deiner Excel Standard-Vorlage via Intune vornehmen, kannst du dies, indem du das «Book.xltx», sowie «Sheet.xltx» und die Version in der zweiten Zeile des «install.ps1» sowie «check.ps1» anpasst. Anschliessend kannst du das Win32 App neu paketieren und in der vorhandenen App im Endpoint Manager hochladen. Don't forget to upload the "check.ps1" again!

1 thought on “Excel Standard-Vorlage mit Intune”

  1. Pingback: Manage Office Templates with SharePoint and Intune | scloud

Leave a Reply

Your email address will not be published.