Building custom solutions that extend, automate, and integrate Microsoft 365 apps.
People are wondering why refreshAllDataConnections has been broken for so long. To me, the reason seems pretty obvious. Microsoft really doesn’t want us using Excel as a “middle tier” for pulling data from other sources. They’d much rather push us towards all the fancy connectors that can do the same thing in a more “official” way. The catch, of course, is that those connectors require a Premium license.
Using Excel as a staging layer is effectively a workaround that avoids those Premium connectors (and the associated costs!) Breaking this path, while keeping the Premium route open, looks a lot like a deliberate push towards more expensive subscriptions and making previously working functionality unreliable or unusable. At best that’s questionable, but if you think it through, it’s pretty disgusting.
So let’s not kid ourselves. I seriously doubt this function will ever be properly fixed. And now we’re seeing alternative routes, like Run script from SharePoint library, quietly stop working as well. Coincidence? Maybe. But it does fit the pattern.
In the end, the choice is simple. Either swallow the Premium costs, or as an organisation start asking whether it still makes sense to keep pouring money into a company that clearly optimises for shareholders first, and for its actual users a distant second.