The end of April has brought new automation tools to Excel Desktop – sort of.

Power Query Refresh is now Generally Available in Excel for the web for queries sourcing data from the current workbook and anonymous OData feeds. Slowly but surely, the full Power Query capabilities are coming to the online variant of Excel!

When Power Query was first released in Excel for Mac, there was hope that it wouldn’t take long for the features to mirror their Window counterparts. It’s taking time, but the capabilities are improving.

Microsoft has recently upped its game with blocking macros. They argue that macro-based malware is on the rise and thus they are blocking macros from more and more external / third party locations. Protected mode seems insufficient.

This month’s revisions include updates for the new Format pane and Power BI Goals, amongst other improvements / new features.

It really seems that the Microsoft Excel team has got its programming claws well and truly into the interwobble version. Excel for the Web has had further improvements this month.

This month’s updates see error bars for Line charts and dynamic format strings support for all chart elements, amongst other new features and Previews.

Microsoft doesn’t want to do things by halves, does it? Yesterday saw the announcement of no less than 14 (!)new Excel functions designed to help manipulate text and arrays in your worksheets. If only we could find some that would massage the financial as well…

…And so they are back! The raft of 2022 Power BI updates starts here, with a slew of new features, including new mobile formatting options, Dynamic M Query Parameters support for more data sources, deployment pipeline enhancements and improvements to downloading a...

At last! LAMBDA and the LAMBDA helper functions are now Generally Available to anyone using Production: Current Channel builds of Excel. In conjunction with LAMBDA going to production, Microsoft has also announced the release of a new add-in, the Advanced Formula Environment, which allows simpler importing, exporting and authoring of named LAMBDAs.