Shane Bartholomeusz

Geek and lover of all things tech related

How To: Unlock Protected Excel Spreadsheet

Overview

Think that your ‘protected' Excel spreadsheet is safe? Think again! These restrictions can easily be bypassed.

In this post I'll show you how to unprotect an Excel spreadsheet in a few simple steps.

Recently I had to do this when the original author of an Excel spreadsheet had left our company and no one had the password to unprotect the document.

Continue reading

How To: Clone GIT Repo Using Personal Access Token

Overview

In this post I'll show you how you can clone a Git repository using a Personal Access Token instead of a regular password.

Personal Access Tokens are useful in a variety of situations. I recently opted to use an access token on a work laptop rather than using my ‘god mode' credentials. That way, if I needed to hand the laptop back to my employer I could easily revoke the access.

Enough talk … lets get to it!

GitHub Icon
Continue reading

Fixed: Windows 10 Search Crashing

Problem

In this post I'll show you how to fix an issue with Windows 10 Search disappearing.

While trying to use the Windows 10 Search I noticed that after I entered a few characters the Search Box would crash and clear out the text I had entered. No search results were being displayed.

Continue reading

Fixed: SPFx Web Part Long Load Time

Problem

While working on a SharePoint Framework (SPFx) webpart I noticed some odd performance issues. My SPFx webpart was very slow to initially load.

I was initially a bit puzzled by this however after some investigation I discovered the below solution.

SharePoint Logo
Continue reading

How To: Create PDF Email With Power Automate

Overview

Do you have a need to generate emails with PDF attachments using the Power Automate (aka Microsoft Flow) workflow engine?

Guess what! You're in luck because in this post I'll show you how to do exactly that. I'll show you how to generate a PDF document and send it via email.

Power Automate Logo
Continue reading

Solved: “You Need Microsoft Dynamics 365 License To Continue” Error

Problem

While trying to reactivate a workflow in our Dynamics 365 environment we encountered the following error. In this post I'll show you how you can solve this issue.

You Need Microsoft Dynamics 365 License To Continue

You need a Microsoft Dynamics 365 license to continue error
Continue reading

Fixed: Configure Visual Studio GIT Proxy Server

Problem

Working in corporate environment can bring it's own set of challenges when setting up tooling. A typical corporate environment will usually contain a Proxy server setup.

If you have encountered the below errors while using the built-in GIT integration with Visual Studio 2019. In this post I'll show you how to fix these issues.

Failed to connect to XXXXX.com port 443: Connection refused

Git failed with a fatal error.

unable to access XXXX

Proxy CONNECT aborted

407: Proxy Authentication Required

Continue reading

Fixed: Windows Update – There were some problems installing updates (0x80240fff error)

Problem

Have you encountered the dreaded 0x80240fff Windows Update error in Windows 10? In this article I'll show you how to fix the issue.

There were some problems installing updates, but we'll try again later. If you keep seeing this and want to search the web or contact support for information, this may help: (0x80240fff)

Windows Update Error (0x80240fff) Screenshot
Continue reading

Fixed: WCF Test Client Max Size Error

Problem

When querying a web service using the WCF Test Client you might encounter the below error message. In this article I'll show you how to resolve this issue.

The maximum message size quota for incoming messages (65536) has been exceeded.

Error message screenshot
Continue reading
« Older posts

© 2020 Shane Bartholomeusz

Theme by Anders NorenUp ↑