Shane Bartholomeusz

Geek and lover of all things tech related

Tag: Excel

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

Solved: Excel 256 Row Limit in MS Flow

Problem

When processing Excel files containing over within Microsoft Flow, you might notice that only the first 256 rows will be returned …

What The? What's Going On Here?

Microsoft Flow and Excel Logos
Continue reading

Handling Excel Dates in Microsoft Power Automate

Problem

Dealing with dates can be a real pain in the proverbial sometimes … and Microsoft Power Automate (aka Microsoft Flow) is no exception.

I recently had to bulk load some records from an Excel file into SharePoint Online using Microsoft Power Automate … you'd be forgiven to think that this would be a trivial task … WRONG!

Microsoft Flow and Excel Logos
Continue reading

© 2020 Shane Bartholomeusz

Theme by Anders NorenUp ↑