It is amazing what AI can do – and even more amazing what members of our team can do with it. Our very own Lennon & McCartney (all rolled into one), Ilgar Zarbaliyev, has “composed” the SumProduct Groove. If you need a laugh (with tongue firmly positioned in cheek), feel free to singalong a SumProduct. No doubt Ed Sheeran will be covering it on his next album, ∑∏!!

Whilst you have been able to refresh a PivotTable upon opening a file for years in Excel, refreshing the PivotTable when the source data changes has been more problematic. Not yet announced in the Excel Updates, Microsoft Excel now provides you with the ability to update your PivotTable automatically whenever you make changes to the data source.

SumProduct is pleased to announce that two of our staff, Tim Heng and Ilgar Zarbaliyev, have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel and Data Platform respectively for 2025-26.

This month sees an important update to the Azure Maps visual in Power BI that gives you greater control over data residency and governance, whilst also simplifying the experience for administrators.

This month’s update highlights several new Preview features and an important action-required item for Power BI users.

This month introduces another raft of improvements, the majority of which revolve around Copilot.

As part of Microsoft’s ongoing efforts to enhance the performance and security of Power BI, the company has announced the deprecation of the 32-bit build of Power BI Desktop.

The May 2025 update introduces a range of exciting advancements to Power BI, including a standalone Copilot feature allowing users to “Ask Anything!” in Preview.

This month introduces several new features across platforms, including value tokens, that infernal Dark Mode and the ability to create Tables with Copilot in Excel.

This month’s updates saw mobile optimised report layouts, the best way to view data in the general availability of Power BI mobile apps, editing your semantic models with TMDL (Preview) and improved layouts for live editing semantic models.