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.

Recently, I needed to modify a protected spreadsheet however the original author of that Excel spreadsheet had left our company and no one had the password to unprotect the document. Doh!

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

Continue reading

Solved: Excel 256 Row Limit in MS Power Automate

Problem

Whilst reading Excel files within Microsoft Power Automate (or Azure Logic Apps), you might notice that only the first 256 rows will be imported …

What The? What is 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

© 2021 Shane Bartholomeusz

Theme by Anders NorenUp ↑