One of my two New Years resolutions for 2019 was to do a better job managing my personal finances. I’ve been a religious Quicken user for about sixteen years, but I was starting to realize that it was doing a great job at telling me what I’d spent my money on, and ensuring that I …
Author: Chris Kibble
Visio cannot open the file or a component in the file because it is corrupt (Visio 2016)
After upgrading a number of systems to Visio 2016, I started to hear more and more about old pre-2010 Visio files in VSD format that would no longer open and would throw the following error: The strange thing was that the files were still launching without issue for users who were still on Visio 2010 …
Making a ConfigMgr Task Sequence Available to a User Collection
A recently had a requirement to bundle a number of applications together into a few different task sequences to make available to a user collection. After a bit of research, I discovered that this is a pretty common question, and that there is no built-in method to make this available. Below, I’ll walk through how …
Remove All Objects from an Excel Sheet
After pasting some content into Excel 365 (2016), I found that I had brought along thousands of little objects from the source data. These were tiny invisible objects, but they’d constantly get in the way of me clicking into a cell, because I’d inadvertently click on one of the objects instead. While I should have …
Convert Office 365 Version Numbers to Build Numbers for SCCM Reporting
I’ve written the following three PowerShell functions to build a mapping of Office 365 ProPlus version numbers (e.g. 16.0.10205.2009) to more reportable build numbers (e.g. 1806). I’ve created the following three functions to start: Get-Office365BuildToVersionMap Get-OfficeBuildListToCase Get-OfficeBuildListToSQLTable