The news that Microsoft is adding Javascript support to Excel is important for developers and regular Excel user, but also a security concern. Javascript is a programming language that’s used on many web pages to provide the fast interaction we’re used to. Javascript is able to get data from external sources and display in Excel […]
Here’s how to convert the Last Trade time in Excel’s Stock data type into an Excel date/time that’s usable in other parts of Excel. UPDATE: near the end of September 2018, the Last Trade Time date format changed to an Excel serial date. No conversion or text parsing necessary. So this tip isn’t necessary any […]
Modern Excel can grab information from multiple files in a single folder. Just open the worksheet, refresh the query and it’s up to date! This article is a condensed version of just one chapter in Real Time Excel – the new 2nd edition has a lot more detail and example files ready to use. […]
Criminal have found another way to (mis)use Microsoft Office and infect computers using the latest ‘zero-day’ hack. You may know that Adobe’s Flash was a popular add-in for web pages to display multi-media content. But Flash was very insecure and unstable so it’s been mostly replaced with other secure systems. Most modern browsers block Flash […]
As usual, Microsoft has released non-security updates and bug fixes for Office 2016 and Office 2013 on the first Tuesday of the month. A few caught our eye: Late last year, Microsoft was caught out leaving a horribly vulnerable Equation Editor in Office for 17 years. A new patch restores the MT Extra font so […]
