Windows will automatically index and let you search Office documents on your computer or network – how can you stop that happening? Maybe the document is personal or so private you don’t want anyone to find it with a Windows Search. Or discover that the document even exists! Password Protection The most direct way to […]
It’s now possible to change the default layout for a new Excel PivotTable. PivotTable default configuration has been on the ‘wish list’ for many years. It’s now in Excel 2016 for Windows, Office 365 customers only as part of the May 2017 update. The changed defaults apply to all new PivotTables made on that computer. […]
Microsoft overuses the term ‘exciting’ to describe their latest work but the new ‘Transform by Example’ for Excel looks genuinely exciting. However you get data for Excel, the common problem is ‘massaging’ it to fit your needs. Dates need changing to match Excel, addresses need splitting into address/state/zip and names separated into first/middle/last. Excel’s Get […]
Everyone is talking about ransomware now that the WannaCrypt has spread like crazy across the world. These nasty viruses target your documents and precious files including Microsoft Office files and Windows backups. This is a little embarrassing for us because Office-Watch.com has just released a new book that’s suddenly become very topical. Everyday BACKUPS – […]
Microsoft has moved quickly to block a security hole in their own anti-virus software, Windows Defender. We’re used to seeing email or instant messaging used to infect a computer when opening a document in Word or Excel, maybe an email in Outlook. But this is quite different and very worrying. The bug is in Microsoft’s […]
