Office

Excel – Something Went Wrong While Downloading Your Template

Excel 2013 and 2016 have a great inbuilt feature of having online pre-built templates available for different purposes. You find them by going to File > New. Templates such as Family Budgets or Back to School Planners. They’re hosted by Microsoft and download the template as you need them:

List of Excel 2016 Templates

Normally you’d pick the template you want, and use the create option:

Creating an Excel 2016 Template

However, there’s a scenario I found that this doesn’t work, and you’ll see the message ‘Something went wrong while downloading your template’:

Something went wrong

After digging around for a bit, I found this Technet thread which mentioned uninstalling Visio Viewer to fix it. Seems strange, but I tried this and it worked. I wasn’t happy with that as a solution though, so logged a Microsoft case.

I went through the process of capturing fiddler traffic and logs, but was then asked a simple question: Was Visio Viewer 32 or 64 bit? I had a look and it was 64 bit, however the Office 2016 suite itself was 32 bit. I quickly guessed that 32 and 64 bit wasn’t a good mix for Office products, even if they were installed separately.

Sure enough, using Visio Viewer 32 bit with Excel 2016 32 bit fixed the problem.

 

TL;DR – Visio Viewer needs to match your Office/Excel install – 32 bit or 64 bit for both.

Microsoft Word – Show all formatting marks

Microsoft Word 2016 and earlier versions have a handy toggle for ‘Show/Hide paragraph marks and other hidden formatting symbols’. It’s that backwards P looking thing in the Word ribbon:

… but also choosable from Word’s options under the Display section, called ‘Show all formatting marks’:

By default, this option is off. I had a business requirement to have it on by default, which proved harder to work out than I thought.

Normally for Word and Office, a user option is controlled by the registry. Procmon is great for capturing those changes, but I couldn’t see anything when toggling this option.

Jeremy Moskowitz from PolicyPak gave me a hint on finding the solution on this one; Word sets some of it’s user settings at the time of closing Word, rather than changing an option and pressing ‘OK’.

Once I knew that, the setting was easy to find.

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Word\Options

DWORD Value - ShowAllFormatting

1 - Enabled / On

0 - Disabled / Off

Word will read this setting at startup, and write to it at shutdown based on what the setting was last set to.

Using Group Policy Preferences and setting the option ‘Apply once and do not reapply’ to push out the registry setting will make it the default, but let users change it as they please.

Outlook 2013 & 2016 Blank Screens and Crashing

Since going from Outlook 2010 to 2016, I’ve noticed several issues. They’re outlined on this TechNet article which lists:

  • Buttons on the Outlook ribbon failing to paint properly
  • Email messages displaying either blank or black in the Reading Pane
  • The Navigation Pane failing to draw all folders properly
  • Various rectangles appearing in the Outlook user interface (UI)

There’s also just Outlook crashing/freezing/running slow. This has been an ongoing problem, and I suspected 3rd party addins to be the culprits. That’s sort of true, however it turns out it’s an overall memory issue with 32 bit Outlook having ~2GB of RAM to access, shared amongst all the 32 bit apps running on your computer.

If you want to know that low memory is the cause of your issues, one way is to use the Sysinternals VMMap utility and follow these instructions. If your free memory is under 250MB, then you’re working below the requirements of what Outlook needs to have available to continue running smoothly.

The article above is very well written and detailed, with the primary remediation suggestion being to go 64 bit Office. This isn’t a short term realistic solution for many companies who have legacy 32 bit addons, or vendors who just haven’t got there with 64 bit addins yet. It only takes 1 addin for that idea to come crashing down, and then there’s the testing of all the re-written apps, and then deploying out; an uninstall of the whole Office 2013 or 2016 32 bit suite, uninstalling all the addins, deploying Office 64 bit, deploying the new addins… it’s potentially a huge project to take on.

There is hope though for those of us who can’t go 64 bit (again the article has many suggestions), which is a new feature called Large Address Aware (LAA). It doubles the amount of memory (4GB) available to the Office apps. It’s already rolled out to Outlook 2016 build 1709. That makes sense if you’re using the Click to Run (CTR) version of Office 2016, but the MSI version that many still use hasn’t got this update yet. Referring to the TechNet article again on this issue, there’s no exact specific mention that LAA will come to the Click to Run version of Outlook 2016, so we’ll have to wait and see.

If you’re experiencing a less than great experience with Outlook 2013 or 2016, it’s worth understanding the above and seeing if you’re affected. This may drive you to change to Office 2016 CTR, Office 2016 64 bit, or even both – or leave you to work out how you can improve the experience, with potentially disabling Outlook addins that aren’t necessary.

I am trying to work with Microsoft on this issue too, so feel free to ask any questions or make any comments and I’ll see if I can assist.

What Is eDiscovery In Security And Compliance In Office 365?

The Security and Compliance area of Office 365 does a bunch of things around securing, managing and auditing the data your organisation has in Office 365, but one area that caught my interest was the eDiscovery options.

eDiscovery is just like email – an electronic version of something that used to be done manually. If you’ve watched shows like Suits, they will show people going through a discovery process by having a room full of boxes, and having to read through all the documents by hand to find whatever smoking gun they’re after.

The ‘e’ in eDiscovery just means that all the data is digitalised (either originally because it’s digital content such as emails or files from computers, or has been scanned to convert the contents from analog to digital) and more importantly, indexed and quickly searchable.

If you were searching for ‘murder’ in an eDiscovery system, you’d put the keyword you want (murder) and point it to the set of data to search against –  just like Windows PCs can index their local data for searching the contents quickly. All documents that contain the word ‘murder’ are presented and can be read through by someone, which makes the manual process of going through a room full of boxes a bit laughable.

This is exactly what Microsoft’s eDiscovery does, with the benefit of already having your existing Office 365 data indexed. This includes all your Exchange Online mailboxes, SharePoint Online sites and OneDrive for Business content.

Microsoft Mechanics have a great demo video on how this works for a keyword search:

Of course the functionality of eDisccovery goes way beyond legal reasons, and the whole Security and Compliance solutions go far beyond the eDiscovery component.

You may also have content you want to search that’s not in Office 365 currently. PSTs can be uploaded then searched against in Exchange Online, or you can upload files to a library (SharePoint or OneDrive for Business) and search against them.

The space and compute power is something you don’t have to worry about (as long as you’ve got enough space in Office 365, which you can buy more of if needed) with this too.

There is a huge amount of documentation online about eDiscovery which will cover a lot of questions and scenarios you may have, but I think it’s best to find some test data and start playing around with it.

I’m learning the basics about eDiscovery myself, but if you’re looking to do a keyword search on a large amount of data, this is worth looking at – and assuming you have Office 365 already, shouldn’t cost you anything to use!

 

 

How To Enable Office 2013 KMS Host

Hi,

Following on from my previous blog on “How to add your KMS keys for Windows 8 and Server 2012, here’s how you can enable a KMS Host (Key Management Service) for Office 2013.

Server End

First, you’ll need access to Microsoft VLSC (Volume Licensing Service Center) here: http://www.microsoft.com/Licensing/ Update: You can also download it from here http://www.microsoft.com/en-au/download/details.aspx?id=35584

From there, under the ‘Downloads and Keys’ section you’ll need to find ‘Office Professional Plus 2013 Key Management Service Host’ or Office Standard Key Management Service Host’ depending what you’re licensed for. It’s a 800kb ISO file.

Once downloaded and extracted/mounted, you’ll need to go to your already configured KMS Host which is running your Windows KMS Host activation. If you’ve already got Widnows 8/Server 2012 running then it could be easier, as there were some patches for the pre-release version of this tool, and that will possibly apply to this proper release.

On the KMS Host, open your command prompt and run the command ‘cscript kms_host.vbs’ (assuming you’ve navigated to the directory containing the extracted ISO). It’ll do it’s thing as per this screenshot:

 

Then, as long as you’ve been kind to the licensing Gods it will prompt you saying that the install was successful, and would you like to enter and activate your Office 2013 KMS key now? Yes please you’ll reply, realising you’re talking to your PC.

Enter your key including dashes (obtained from VLSC under the actual Office 2013 product download) and nervously wait, while it gives no indication anything is happening for 10 seconds or so. Eventually you’ll get another prompt saying the key has been successfully installed and activated. You will be able to see this from the Volume Activation Management Tool under the ‘Licensed’ area.

Client End

The Office 2013 client automatically installs using the client KMS. There are two keys remember, being the KMS Host and KMS Client. The KMS Host is obtained via VLSC and individual to your organisation, while the KMS Client key is standard worldwide, and the default for install. The KMS Client key is also referred to as the Generic Volume License Key (GVLK). More info including the publically available keys here: http://technet.microsoft.com/en-us/library/jj219430%28v=office.15%29.aspx

To force client activation, run the command ‘cscript ospp.vbs /act‘ from the C:\Program Files (x86)\Microsoft Office\Office15\ folder. More info on that here:

http://technet.microsoft.com/en-us/library/ee624350%28v=office.15%29.aspx

You’ll now probably get an error saying “The count reported by your Key Management Service (KMS) is insufficient.” with an error code 0xC004F038.

I believe you need 5 unique PCs to request a key before your KMS Host will start giving them out (reference for Office 2010 http://blogs.technet.com/b/odsupport/archive/2010/06/14/troubleshooting.aspx). I haven’t had a chance yet to test this, so please let me know if you find out more.

Update: As confirmed by this page, you need 5 unique PCs http://technet.microsoft.com/en-us/library/ee624358%28v=office.15%29.aspx