Browse the archive

Tag: Excel

Miscellaneous 11th November 2020

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 […]

Read article

Microsoft Flow 12th September 2019

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 … Hmmm …. What is Going On Here?

Read article

Microsoft Flow 15th August 2019

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 […]

Read article