There’s a new Office security bug that can be exploited with just an email or calendar invite as well as the more common infected Office document. The new Office exploit uses the long-standing DDE system which allows Office documents to ‘talk’ to each other. Until told otherwise, best to assume
Ever since Microsoft added shared, collaborative documents via OneDrive, they’ve had problems with saving and sign-in. Here’s how to deal with some of those persistent bugs. These bugs can happen in Word, Excel, PowerPoint or OneNote. Most commonly with documents saved to OneDrive but also Dropbox or other cloud storage.
It was a small but long awaited addition to Excel for Windows but now it’s disappeared? Why did the Chart option “Show #N/A as an empty cell” go missing? There was a small cheer in the Excel charting community when Microsoft put this extra option in the Chart | Hidden
A list with groupings (like Product Type, Country, Region or Staff pay level) can become a nested PivotTable. The sub-totals are created with + – signs to show/hide the groupings. We’re using the same source list as in our Basic PivotTable and Two-dimensional PivotTable examples. Doing that is simple, just
We started with a simple Excel PivotTable, now let’s move on to a multi-column or two dimensional PivotTables. They aren’t a lot more complicated than a basic PivotTable, just add a few more fields. We’ll start with the same sales list that we used for our PivotTables 101 article. This
Who knows how long Outlook has been sending supposedly encrypted emails with a plain text readable version included? Microsoft isn’t telling their customers, presumably hoping we won’t notice. SEC Consult discovered a serious breach in Outlook’s email encryption system. Secure messages were being sent with a plain text readable version
Bluetiful will be the new Crayola color. It’ll be generally available from January 2018 or you can use it right now in Microsoft Office with these tips. Office-Watch.com told you about the demise of Dandelion, the now defunct Crayola color. And we showed how to keep Dandelion in your Office
PivotTables really are great and we’re not just saying that because it was one of Bill Gate’s favorite features. The original PivotTable feature was clumsy and difficult so you’re forgiven for trying them and giving up in disgust. Mayurakshi wants to show you some of the nifty parts of PivotTables
Making your first PivotTable can be scary so here’s a quick ‘How to’ to get you started and past the scary bit. It’s a PivotTable starter article for anyone who hasn’t dived into PivotTables already and before we start with the tricks and tips for this important part of Excel.
Outlook for Mac is a disk space hog but the macOS has a way to recover some of that. Mac computers can have relatively small hard drives like 128GB or 265GB which Outlook 2016 for Mac can gobble up. Unfortunately, Outlook for Mac, even the latest Outlook 2016 doesn’t have
10 October 2017 was an important date for Microsoft Office. It marks the end of support and updates for all ‘flavors’ of Office 2007. From now on there’ll be no updates or patches. Not even security patches to fix vulnerabilities available to hackers. It applies to the entire Office 2007
The October bundle of Office security patches includes one for a bug that’s already known and being used by hackers. Known as CVE-2017-11826, this is a Word bug which allows a malicious RTF/DOCX combination to access your computer. The attack uploaded all the documents, images etc that it could find
The prices of Office 365 Home and Personal go up in Australia. Only four days from now on Thursday 12 October 2017. Now’s the time to save before Microsoft grabs more money. The price increase hasn’t been widely reported and Microsoft Australia is keeping important details to themselves. Here’s what we
Money saving tips for all Office 365 customers when a price increase is about to happen. There’s an opportunity to save some money by buying in advance of any price rise. Office 2016 the real startup guide has a lot of detail about the cheapest ways to buy Microsoft
Last week Microsoft ‘announced’ Office 2019, we put ‘announcement’ in quote marks because they said very little. There’s been a lot of guesswork, mostly hopeful guesswork, about Office 2019. Even at this early stage, it’s time for a reality check on Office 2019. Office 2019 will be the next version
Office 2016 for Mac is getting some big improvements in the next few months. That’s not just Microsoft hype, it seems very real. Last week, Microsoft quietly declared that they were making some big changes to how Office 2016 for Mac works. Those ‘under the hood’ changes would let them
How easy is it to switch from the one-time purchase/perpetual licence version of Office 2016 to the Office 365 annual payment / ‘subscription’ version? You might think that the switch is no big deal but it’s not just about how you buy Office 2016. The perpetual licence version is installed
Microsoft has released to their ‘Fast Track’ some improved Translation features in Word 2016 for Windows. The new Translator is cloud powered and will eventually flow to all Office 2016 ‘subscribers’. Yes, even Office 2016 for Mac! The new features replace the existing Research Pane and Mini-Translators. It’s only for
Here’s how to control what Outlook does when it gets a Read Receipt request with an incoming email. The setting is at File | Options | Mail | Tracking, just below where you set the options for outgoing Read Receipts. That’s Outlook for Windows, see below about Outlook for Mac.
Here’s how to send one or all emails from Outlook for Windows/Mac with a Read Receipt. On the Outlook for Windows ribbon | Options tab there’s a ‘Request a Read Receipt’ option. Outlook for Mac Read Receipt Outlook for Mac it’s also on the Options tab Read and Delivery receipts
It’s possible to run Microsoft Office on a Linux computer and Zorinos makes that easier than most. The Linux operating system can be combined with ‘WINE’ which allows many Windows programs to be run on Linux directly. Zorinos comes with WINE ‘baked in’ to the operating system, saving the hassle
A new vulnerability in Word was discovered and patched by Microsoft earlier this month. Again, the source was an RTF (Rich Text Format) document. There’s still a widespread myth that RTF files are ‘safe’ supposedly because RTF’s can’t contain macros. That’s FALSE. .RTF documents aren’t designed to accept code, they
A table bug in Word 2016 for Windows was caused by not one but two different software patches with customers expected to wait up to two months for a proper fix. The trouble started with 8 August 2017 patch and continued a month later with the 5 September 2017 patch.
Microsoft has announced a new version of Office for release in the second half of next year. Here’s what we know and what we don’t about the ‘year away’ Microsoft Office. One-time or perpetual licence only This Office bundle is for one-time or perpetual licence buyers of Office only. People