Please note javascript is required for full website functionality.


Restrict Usage of Excel 4.0 (XLM) Macros with New Macro Settings Control

27 July 2021

A new Excel Trust Center (sic) settings option to further restrict the usage of Excel 4.0 (XLM) macros has now been made Generally Available. To better protect Microsoft 365 users against malicious macro-based threats, Microsoft recently expanded the integration of what is known as the Antimalware Scan Interface (AMSI) with Office 365 to include the runtime scanning of Excel 4.0 (XLM) macros.

July 2021 Updates for Power BI

23 July 2021

This month’s updates see small multiples become Generally Available, the new Model View / sensitivity labels in Desktop are propagated, plus there is a new Preview for streaming dataflows.

MVP Renewal

2 July 2021

SumProduct is pleased to announce that two of our Directors, Liam Bastick and Tim Heng, have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel for 2021-22.

Lifetime Achievement Award

28 June 2021

Even if it does appear to mean blowing smoke up our own proverbials, we have some great news! Congratulations to SumProduct’s very own Liam Bastick who won the inaugural Lifetime Achievement Award at last week’s Financial Modelling Summit 2021, held in London.

New Features in Excel for the Web June 2021

28 June 2021

The General Availability of Office Scripts is only one of the new features and improvements to help you better analyse your data. There is more.

June 2021 Updates for Power BI

27 June 2021

This month’s updates include DirectQuery support for Dataflows, which has now become Generally Available.

Office Scripts now Generally Available in Excel for the web

17 June 2021

Microsoft has recently announced that Office Scripts in Excel for the web is now Generally Available for all “eligible users”.

Import Data from Local Files using Power Query in Excel for Mac

20 May 2021

We are pleased to hear that there is new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files, coming on the back of being able to refresh data from, er, about this time, last year. Tempus fugit indeed!

May 2021 Updates for Power BI

13 May 2021

This month’s updates include a new Preview of visual ToolTips, an ability to quickly create reports from SharePoint lists and an update on sensitivity labels so that they are now inherited “downstream”.

Recommended Files

9 May 2021

Microsoft Office now displays a list of recommended files on the File tab, or start page, of Word, Excel, or PowerPoint on Windows. This list allows you to keep track of work around you and quickly access files with activity you value most such as edits, mentions, comments by people you interact with.