Excel 365’s new Stock data type has the potential to be really great. Here’s how to report problems to Microsoft so they can fix them. Real people read the bug reports, especially for a new and developing feature like Linked Data Types. The bug reports help Microsoft staff identify problems and also give them a […]
A truly interesting new Excel feature is now going public. Stock and Geography are the first two Linked Data Types (LDT) that bring stock prices and geographic info direct into Excel 365. Stock data type gives you information on stocks and indexes from over 60 global stock exchanges. No messing about with PowerQuery, ‘Get and […]
A previously theoretical way to misuse Office documents to infect your computer is now ‘in the wild’ and Microsoft isn’t interested in stopping it. Last week we told you about a new way for Office documents to get malware onto your computer. Cymulate discovered that the Online Video feature could be manipulated to download malware […]
A little side-trick for converting text dates to Excel dates is replacing the text separator. Excel lets you replace text within the selected cells only. If the text dates are in the correct order (e.g. m/d/y ) but use the wrong separator for your Windows regional setting (e.g. m-d-y ). Excel’s Replace function will replace […]
Cymulate is reporting how embedded video in Word or other Office documents are another way for criminals and hackers to infect your computer. It’s yet another example of how Word, Excel or PowerPoint documents can be used to get malware onto computers to steal data, becomes bots or other nasties. This trick uses the relatively […]
