SharePains by Pieter Veenstra on MSN

The scalability of Office scripting in Microsoft Excel

Today's post is all about the scalability of Office Scripting in Microsoft Excel using the Run Script action in Power Automate. Do you know the limitations for solutions based on Office Scripting?
We all know that Excel isn’t a good place to store your Power Apps data in. Still way to often developers use large Excel files for their Power apps data. But why is Excel not a good data source? Why ...