The UK has been embarrassed (again) with the news that around 16,000 COVID-19 test results were missing from the official database and so contact tracing wasn’t done. The culprit? Excel. Or, to be fair, bad use of Excel is to blame. Not understanding it’s limits and how to workaround them. We’ve tried to figure out […]
Microsoft has done a clever thing, combining two important Excel features into a new and really useful addition – Custom Data Types. Excel 365 for Windows/Mac already has Stock and Geography data types to drop live information into workbooks. It’s now possible to make your own Custom Data Types (CDT) that work the same way. […]
Office 2010 ends support on 13 October 2020 and we’ve been receiving questions from readers asking about switching to newer Microsoft Office. We’ll answer questions about when to update, what to replace Office 2010 and important factors to consider. We’re hearing concerns about privacy in modern Office, reliability and the constant, monthly, changes in the […]
Common programming tools can be used to make malicious Office workbooks which bypass both online security checks and Microsoft’s own protections in Word, Excel, PowerPoint or Access. We’ll explain what’s happening and what Microsoft could do better. VBA Purging or VBA Stomping are clever tricks to make an Office documents (e.g. .xlsm Excel workbook) with […]
Everyone with Microsoft 365 can get a ‘quick poll’ now with any email account or software. No need to wait for the Outlook Quick Poll option, now in preview for Microsoft 365 customers with Outlook for Windows. As we’ve already explained, Quick Poll is a simple and very limited way to add a Microsoft Forms […]
