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
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?Continue reading
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!Continue reading