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.
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.
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!
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”.
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.