Here are two options to stop Microsoft Office for Windows from automatically updating itself and why you might want to do that. Office for Windows All versions of Office that have current support (currently Office 2010 and later) get: updates to fix bugs in the software patches to stop security
He’s done it again, David Peel has quickly made up a new version of his Excel Year Planner that starts the year from any month you choose. Great for academic years (start in August) or financial years (e.g. Aussie start in July). The year selector is top left of the
The second Access memory leak has finally been patched by Microsoft, almost a year after a very similar problem was discovered. These bugs have been around since 2002 and the effects are still in some Access files. Both are faults in the way Access saves data to memory locations in
PivotTables and PivotCharts from scratch in a new edition strips away the techobabble so you can make your own PivotTables and make sense of any list of numbers or information. We do that with plenty of step-by-step instructions and, crucially, Excel worksheets you can open and try for yourself. Understand PivotTables by looking at expert examples,
It’s possible to apply individual cell formatting in Word consistently using a little VBA code. In effect it makes styles for cells in a way that Word itself won’t do. Reuse this code to apply the same formatting to many cells. Cell Format Special We’ve made two VBA functions for
Nested IF statements can be hard to understand and manage but there are alternatives which can be easier to handle, fix and change. We’ll start with the relatively simple example we used for demonstrating IF and nested IF. =IF(C2>89,"HIGH DISTINCTION",IF(C2>79,"DISTINCTION",IF(C2>69,"CREDIT",IF(C2>49,"PASS","FAIL")))) This example has only five levels of nesting, we’ve seen
Are there any advantages to getting an Solid State Drive (SSD) when running Microsoft Office? We have some advice from actual use. Solid State Drives are faster and power saving drives that are now less expensive and more available, but are they worth the trouble for Office users? YES —
Criminals don’t even respect Santa and the festive season with malware infested emails pretending to be holiday schedules or the Christmas party. Is nothing sacred? Cofense Labs report that Emotet botnet is being spread via Word documents with timely emails for the end of the year. All these dangerous emails
The latest ebook from Office-Watch.com is a little different, it’s a heartfelt ‘Thank You’ to our Office Watch donors. Peter and Victor have again been quite astonished and humbled by the generosity of readers to our reader appeal. Both the money and kind remarks have been a considerable morale boost
An Office 2019 offer that looks like a good deal for just $39.99 or maybe a scam? Microsoft seems to endorse the seller with a mention and link from Microsoft.com so how could it be wrong? We’ll explain why we know it’s not a proper offer, so you can judge
Pantone has announced its Color of the Year for 2020 here’s how to get it in Microsoft Office – Word, Excel, PowerPoint, Outlook etc. The color of 2020 is … Classic Blue Source: Pantone As usual what’s more amazing than the color is the description from the ‘Pantone Institute’. Classic
Sometimes we want to change the margins around a Word document, either to change the way the page looks, or to get the text to fit onto the page. To do this, go to Layout > Margins or use the Ruler to drag the margins. There are several default options
Just one of the many tricks to get people to giveaway their password is a bogus ‘system delay’ email, supposedly from your network administrators. The fake login page is given extra credibility being hosted on a Microsoft server! It starts with a fake message from the ‘Excel Team’ saying you
‘Tis the season for savings on Office 2019 so we’ll keep an eye on price discounts on Office 2019 bundles (Home and Student, Home and Business, Professional). What price to pay and what NOT to pay. Below is a guide to whether a price for Office 2019 is a good
I ♥ or I Love signs or logos can be made in Word or PowerPoint to liven up a document or presentation. We’ll show how to make something similar to the famous and much copied logo. The official ‘I ♥ NY’ logo complete with registered trademark. The original ‘I Love
Oh what a tangled web Microsoft weaves …. a patch for Office has caused another bug in all versions of Access (365, 2019 back to 2010). The bug is the latest in a series of blunders for Office updates. It’ll take until next month for all customers to get a
Here’s how to block .IQY web queries in Excel that are being used to infect machines with Buran ransomware. Yet again, a mostly forgotten part of Office is being used by hackers to get inside computers and networks. Suspicious Link (great name) found this nasty in an email. It pretends
A wonderfully independent article in the Washington Post reveals a big problem with the sale of fake and pirated products on Amazon. Our articles on fake Microsoft Office products is just a tiny part of a bigger problem. The Washington Post is owned by Jeff Bezos, the head of Amazon
PowerPoint has options for hiding slides and also hide & reveal text or content within slides. We have looked previously at hiding things in Word and Excel, and PowerPoint also allows you to hide things, although the approach is a little different. The most common reason to want to hide
If you have a slide that you want to keep in your PowerPoint deck but don’t want to show them in a presentation, you can hide those slides. Go to the strip of slide thumbnails down the side of your project and select the slide you want to hide. You
OneNote for Windows has a better future after some reverse-course announcements from Microsoft. OneNote desktop program gets extended life and a promotion. The desktop and app versions merging into a single codebase. We’ll also explain the strange case of two OneNote for Windows. The announcements amount to a 180° reversal
The first sign that OneNote 2016 is back from a slow death is the announcement of the first new feature in well over a year. OneNote 2016 is getting a Dark Mode just like the Mac and Apple apps. OneNote dark mode will be an option in OneNote 2016 for
Word is very clever dealing with Hidden text, perhaps a bit too clever at times. Here’s some tricks for positioning and formatting with Hidden text. Students quiz (left) and Teachers version (right) from the same document. The answer text is hidden in the student version but there’s still space for
While we were looking for Publisher 2019 on Amazon, we found more obviously illegal sales of Microsoft Office products. We’ve mentioned this before. Blatantly illegal Office licences sold on Amazon by third-parties. Why is this MS Office is illegal? Office 2019 Professional Plus is not sold retail. It’s only sold
