Not a lot, to be honest. Everyone seems to have an opinion about the new iPhones so I’m joining in from the side-lines with some comments and a little reality check on some especially silly remarks from Apple. iPhone 14’s have two different but faster chips which means Word docs,
The wonderful Excel Formula Bot has a new look, more features and has gone ‘pro’ with paid subscriptions. The whole site https://excelformulabot.com/ has been revamped with a cleaner, clearer look. Excel Formula Bot is certainly up-to-date, as you can see above, it already ‘knows’ about the new Image() function despite
Excel users are rightly interested in Lambda() a very powerful addition to Excel. Lambda lets you create user-defined functions without VBA. No need for .xlsm files with all the security concerns they entail. A long formula can be written once then referenced anywhere in the workbook by a short name of
Handwrite direct into Office apps for iPad, converting your writing into text right away, courtesy of the iOS Scribble feature. What you’ll need, how to setup and the new thing to look for on the Draw tab of the Word, Excel and PowerPoint apps. Microsoft has integrated the Scribble feature
Microsoft is now showing deceptive, disguised ads into Outlook Mobile apps for Apple and Android. There are ways to, partly, get rid of the ads. The ads appear for people using the free Outlook mobile apps, not Microsoft 365 subscribers like this: The ads appear in the Inbox or the
Old email addresses or people have an annoying habit of appearing in Outlook, even after you’ve deleted the address or person from the Contacts list. Here’s why obsolete emails keep appearing and how to remove these unwanted and dangerous strays. Here’s an example of Outlook’s problem with ‘sticky’ and unwanted
When the Stock and Geography data types disappear from the Data ribbon in Excel here’s how to fix and restore Linked Data Types. The Data ribbon is missing the entire ‘Data Types’ section. We’ve had several reports from Office-Watch.com readers who start Excel 365 and find that their Stock and
An important and useful new option is coming to Word 365’s collaboration options ‘Review only’ aka ‘Reviewing’ mode. There’s also a workaround to get a similar power in other versions of Microsoft Word. Until now sharing a document was only possible in two ways. Either sharing the editing of the
Segoe Fluent Icon is a handy extra symbols font with some icons that aren’t easily available anywhere else. It’s free for Windows and Mac. Here’s how to use it in Word and Office. Segoe Fluent Icons is intended for use by developers making their Windows apps but there’s no reason
A new embarrassment for Microsoft as they scramble to fix a bug in Outlook 365 for Windows which crashes when trying to display some emails, most commonly receipt emails from Uber. Office Watch goes into detail of this bug. It’s more serious than just blaming Uber for a bug in
Microsoft has resumed rollout of their new Office macro blocking system after the feature was mysteriously suspended a few weeks ago. But why? Microsoft hasn’t explained why they stopped the new macro blocks and their reason for restoring the feature is both incomplete and nonsensical. The new system totally blocks
How to view a .msg file in either Windows or Mac. .MSG are Outlook for Windows message files which aren’t supported on Outlook for Mac, let alone Outlook mobile or in a browser. We’ve already explained about Outlook .msg files and why they are NOT recommended. In short .msg files
Microsoft was addressing the long-standing problems with Excel 365 importing text files (.CSV) by adding some options to prevent common conversion problems. The ‘Automatic Data Conversion’ choices are welcome, but you’re still better using other, safer, Excel import options. NOTE: this feature has been quietly dropped by Microsoft. The Automatic
If you get an unexpected phone call from Microsoft, hang up on them. It’ll be a scam where you could lose thousands and precious personal data from your computer. We’ve mentioned this before but reminded by this Australian article warning that just in ‘Oz’ people have lost an estimated AUD$2
Officially a Gauge, dial or speedometer chart isn’t available in Excel. It’s a glaring omission from the in-built Excel charts but happily, it’s still possible with a little Excel trickery explained in this article. A “speedo” (Aussie slang), dial or gauge chart is made with a combination of Excel’s Doughnut
Despite appearances, Microsoft Word’s Grammar and Style checks are not compulsory. There are simple but somewhat hidden controls to turn off the blue underline or dots for selected tests. This article explains how to selectively turn of Microsoft Word’s “Grammar and Refinements” checks either once only or for all your
Australian data nerds rejoice! The first load of data from the 2021 Census has been released in a format ready for Excel. Here’s how to get it and look at the detailed statistics for yourself. The Australian Bureau of Statistics has just released the first block of data from the
Let’s take a moment to see where customers stand with Dark Mode options in Microsoft Office in Windows, Mac, iPhone, iPad, Android and web. It’s easy to get confused about Microsoft 365 and Office 2021 dark mode or theme options. Microsoft has announced ‘dark’ developments so many times it’s hard
How to run administration commands via PowerShell for Microsoft 365 hosting and especially Microsoft 365 Exchange Server or mailbox hosting. Microsoft 365 customers will often see instructions like this to configure their Exchange Server mailboxes using PowerShell. Set-OrganizationConfig -AllowPlusAddressInRecipients $true Looks simple, but that command alone won’t work in PowerShell
A large security risk has appeared in Microsoft Word, a zero-day security problem which can infect even fully updated Word. Microsoft has taken at least 14 months and still hasn’t fixed the security hole. We’ll explain the problem and what you can do. It’s a relatively simple hack which takes
Microsoft Word has many different ways to view a document and now three primary options are available on a single menu; Editing, Reviewing plus Viewing which is a simple ‘read only’ mode to stop accidental changes while reading. The new menu appears on the top-right between the existing Comments and
Microsoft has released a new Outlook for Windows which is so limited that we feel it’s necessary to warn people about trying to use it. Beware! Even for Insiders on the ‘beta’ channel this new Outlook is no replacement for the real Windows version of Outlook – not even close.
Does Microsoft Word recognize the nicknames for ‘big numbers’ like zillion, jillion etc? There are many informal words to describe a non-specific but really large numbers. Word’s dictionary (at least in English) recognizes them as correct spellings. If you want to be more specific see Real words for really big
Excel Sheet View is Microsoft’s fix for a problem when sharing an Excel list or table among many people. We’ll explain how it works and what’s happening behind the scenes. A shared Excel list can be sorted or filtered in many different ways. It’s quite possible that two people can
