It’s quite easy to tell if your Excel 365 has the new Dynamic Arrays. No need to setup a table and use the new feature – just three keypresses are enough. Some people are reporting that they have the right Excel 365 but with no dynamic arrays. Checking the program/app
Microsoft says that Dynamic Arrays have arrived but Excel 365 users beg to differ. Despite the company’s written assurances, the promised feature is nowhere to be seen. Plenty of reports that Excel 365 for Windows version 1907 (Build 11901.20176) does not have the important new feature Microsoft says it should.
After many months of testing, all Excel 365 apps now have dynamic arrays (except Excel Online) though some are just for Insiders at present. Dynamic Arrays are a major and powerful expansion of Excel’s powers. The new abilities, functions and error messages might seem scary but are a great leap
A new option in Office 365 for Windows is the ability to choose how hyperlinked Office files are opened. Inside Word, Excel or PowerPoint or in the default browser. The new option is at File | Options | Advanced | Link Handling Open supported hyperlinks to Office files in Office
A newly promoted UK politician has his own special style guide for staff, here’s some Word features that can help ensure your documents are approved by the boss. The Right Honourable Jacob William Rees-Mogg (to give his new full title) proudly affects an old-fashioned demeanor and has been described as
Hackers continue to trick people into giving away their Office 365 login details with a little help from Microsoft. The criminals are getting cleverer by not only stealing passwords but checking immediately and hiding the theft while they copy your mailbox. Avanan has the details on this latest type of
Word is getting reminders for accessibility before making a PDF. When Word makes a PDF version of a document, it includes accessibility tags. These tags help screen readers (spoken for blind and the visually impaired) and also adjusting the PDF for small and large displays. When saving a PDF (File
Yea, gods. Clippy is a persistent little beggar. Over 20 years since it infested our screens and it’s now being used as a dating meme by people not born when Office 97 annoyed us. The infamous Office paperclip, Clippy, continues to pop up just like it did in Office 97.
Microsoft says we should stop calling the browser-based version of their apps ‘Office Online’. It’s now just ‘Office’. ‘Word Online’ is now just ‘Word’. ‘Excel Online’ is ‘Excel’, ‘PowerPoint Online’ is merely ‘PowerPoint’. Make sense? No, we don’t understand either. Microsoft’s explanation of the name change doesn’t help. According to
In August there’ll be some good changes to Office 365 activation for commercial customers. The per device activation limit will be handled in a much better way. Each Office 365 user is limited to login/activations on five each of desktop programs, tablet apps and smartphone apps. That’s a total of
Microsoft’s Home Use Program is a great way to get Office cheaply including Office 2019, Visio Professional 2019 and Project Professional 2019. The Home Use Program (HUP) has been a way to get Microsoft Office for less than retail for a long time. It’s available to many companies, organizations and
A new Windows 10 (October 2018) patch fixes a bug with Office 2010 and updates Brazil time zone data used by Outlook. The patch KB4505658 fixes a long list of Windows 10 v1809 bug fixes. Sorry, they aren’t bug fixes, the euphemism is ‘quality improvements’. Two changes stuck out for
Microsoft Word for Android has reached a billion installs. That’s a real Billion not a Microsoft hype billion. It’s even more impressive than it seems. The billion number is counted by Google on Google Play. Microsoft loves quoting high numbers especially ‘Billion’ even when it makes little sense. But this
Microsoft Word has several ways to quickly insert placeholder text into documents. Sometimes you want to add some random text to a document as filler, but don’t want to think of something to write yourself. While there are websites that will generate placeholder text for you, it is also possible
Our articles about saving past events with anniversary reminders begs the question; How far back can Outlook save an event. The answer in Outlook for Windows, Mac and online is 1 April 1601. Trying to enter a date before 1st April 1601 brings up an error: “You must specify a
Here’s a practical example of how to share an appointment or event with reminders using the iCalendar .ics standard. Some Apollo 11 events ready to download and add to your calendar (in Outlook or other software). Outlook supports .ics files and so does most other calendar programs. They are small
Here’s the enhanced Apollo 11 mission timeline as an Excel worksheet. Office Watch newsletter readers asked for it after last weeks articles using the NASA web page as a data source. Complete Apollo 11 timeline in Excel Things to do with the Apollo 11 timeline in Excel Apollo 11 suggested
The 50th Anniversary of Apollo 11 has unleashed so many books and videos you could easily trip over them walking down the street. Our Editor-in-Chief, Peter Deegan, has been a NASA nut since well before July 1969. Friends have asked him for recommendations of what you see and read …
An Excel worksheet with Apollo 11 timeline can be used to analyze and breakdown the astronaut’s movements plus answer the big question: what time was it when Armstrong walked on the moon? See how we put the Apollo 11 timeline into Excel using Get & Transform or the older Copy/Paste
NASA has a detailed web page with the timeline of the Apollo 11 mission from before liftoff to well after splashdown It’s an example of the two ways to put a web table into an Excel worksheet. Newer Excel (365, 2019 and 2016) has PowerQuery with ‘Get and Transform’ which
One way to get a web table into Excel is simply to copy the page from your browser into an Excel workbook. This method works for all versions of Excel back more than a decade. It’s been superseded by Get and Transform with PowerQuery which does a much better job
SoftMaker’s FreeOffice 2018 has received a major revision. Possibly borrowing from Microsoft, the July 2019 release is called the Anniversary update. A few years ago, Windows 10 got an ‘Anniversary’ update. Anniversary of what was never made clear and didn’t seem to matter. Some of the interesting features in FreeOffice
Emails claiming to be OneNote Audio files are really a trick to steal your Microsoft login and password. They use Microsoft’s own SharePoint.com and Windows hosting to fool people. Bleeping Computer with help from ransomware hunter Michael Gillespie show examples of a phishing email which claims to be from a
Microsoft Teams is claiming a numerical victory over it’s rival, claiming that their Teams collaboration service has more users than the rival.. Teams daily has 13 million users and to 19 million users over a week, according to Microsoft. Source: Microsoft That’s a unaudited and self-serving figure. Microsoft ‘has form’
