It’s amazing to see how people use Excel in ways probably not dreamt of by the programs makers. We usually think of Excel as a financial tool either for businesses or personal budgeting or managing lists. Anything to do with numbers or lists has a place in Excel, like a
A report commissioned by the Dutch Ministry of Justice and Security warns government departments NOT to use Microsoft Office Online or the apps for Apple or Android. The Privacy Company report was made public with the Ministry’s permission via two blog posts short and long. Many governments and organizations have
Office-Watch.com reader Jeffrey J. offers this look at Emailmerge.cc an add-on that fixes some limitations in the Word/Excel/Outlook mail merge system. “ Outlook email merge function does not allow multiple To line addressees, nor allows creating any cc or bcc addressees. And you cannot customize the Subject line. Manually adding/modifying
Microsoft is improving (fixing?) the activation system for Office 365 Home and Personal customers. This comes a few weeks after they announced the same changes for Office 365 Enterprise customers. The per device activation limit will be handled in a much better way. Each Office 365 user is limited to login/activations on
The latest release of Excel 365 for Windows is a right mess with missing Dynamic Arrays and, for a while, Stock and Geography data types disappeared too! We received some reports late Friday, US time that Excel 365 for Windows v1907 build 11901.20176 wasn’t showing Stock or Geography data types
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
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
