3D Formulas in Excel allow you to make calculations using data from many different worksheets, including ones that don’t exist yet. This can be incredibly useful, when you have similar figures for different periods across worksheets and want to use data from all of those periods. For our example, we have a file with expenses for a number of years, a different worksheet for […]
A new Windows 10 bug patch has some fixes for Microsoft Outlook. Microsoft’s documentation is typically brief, so we’ll fill in some details. The time zone changes are too late to help some customers … why? KB4520062 has many Windows 10 fixes but a few affect some Outlook users and anyone using the new Windows […]
Over time there’s been a change in the way email programs login to your mail host. It’s mostly hidden from us mere humans but important to understand. Here’s how to use oAuth and how to bypass it, if your email program doesn’t support it. Older versions of Outlook don’t know about Open Authentication but there’s […]
Outlook on the web is now blocking another 38 email attachments because they can be carriers of viruses. But Microsoft doesn’t block the most commonly used files for infecting computers. Far and away the most common infected email attachment is old-style Word documents, with .doc extensions. Excel .xls worksheets and PowerPoint .ppt presentations are similarly […]
As we suspected, there are more holes in the Office Document Inspector. Our clever readers came up with some possibilities for revealing secrets in documents, worksheets and presentations. Document Inspector is good but could be better. As you’ll see, there really should be a warning about objects with multiple layers. The biggest problem with Document […]
