A recent Windows update is causing VBA code to fail in Excel, Access and other VBA parts of Office. The culprit isn’t Office, but the version of Windows that it’s running on. After the 2019-08 Cumulative Update KB4511553 is applied, some VBA code will stop working. The patch bug is
Despite all the possibilities for importing or sharing appointments, most of the time we have to manually type in new appointments or events. Here’s some tips to do it faster and get it right. We’ve all been there, a web page or email (below right) with details that need copying
The Format Cells dialog can be accessed from Home | Alignment | Orientation, or by right-clicking on selected cells and selecting Format Cells. See Excel’s text and number alignment choices Text formatting in Excel with wrapping, line breaks and merging This dialog gives you more detailed options to choose from than
Under Excel’s Home | Alignment ribbon you can change the indents, alignment or angle of the text in selected cells. As usual, a seemingly simple set of buttons have some hidden tricks. See Text formatting in Excel with wrapping, line breaks and merging Alignment Adjust alignment of the text, both
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
Word allows you to insert other files with data and functionality from another document or program directly into your Word document. Microsoft calls these additions ‘Objects’ which makes it sound overly technical and difficult but it’s not. Don’t get fazed by all the nerd talk about ‘objects’, that’s programmer speak
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
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
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
The 50th anniversary of Apollo 11 is our excuse to show-off some features in Outlook for Windows/Mac. How to add past events, post events in other time zones, get reminders of upcoming anniversaries and set reminders for longer times than Outlook allows. Adding Past Events Outlook can save details of
Back in the 16th Century, italic fonts were invented and that trick can still be used today in Microsoft Word. Italics let you fit more text into the same space. An innovative Venetian publisher, Manutius, needed to make small and affordable books. Paper was expensive so anything that put more
Word lets you translate an entire document in one go, either right click anywhere in the document, right click and select Translate, or go to Review | Translate | Translate Document. As with translating a selection, the Translator will open in a sidebar, where you can select the languages to
Word has a feature to translate text from one language to another. Whilst the translation may not be perfect, it does give you a starting point to understanding what the text says. You can either translate a selected piece of text, or the whole document. Translate works slightly differently depending
If you’re the sort of person who’s easily distracted, or just want to focus on the content of your document without worrying about formatting, there are a number of ways you can clear the distractions from Microsoft Word, so you can focus on the text you’re writing. Minimize the Ribbon
The Power Query exploit in Excel is a concern but one that most Excel users are already protected from. Look past some of the shock headlines (e.g “120 million users personal information at stake due to Microsoft Excel flaw”) . Mimecast did a good job tracing this security bug in
Drop-down list boxes are useful in Excel but, like many things in Office, there’s more than one way to do it and more to know that the simple examples often given. Making a pull-down list is easy and there’re many tips showing the basics. In this article we’ll go beyond
Here’s some other problems with the Word Sort feature and tricks to work around them. Generally speaking, long or complex sorting is better done in Excel. Excel has much better data management features to split and sort. The final result can be copied into Word. Sort a list of names
Microsoft has released a series of pages describing their support for the new Japanese era in Windows, Office and .NET. Plus a new Windows feature to support a nicety of Japanese date formatting. Japan’s traditional dating system works around the Emperor’s reign. The abdication of the last Emperor and enthronement
As part of Microsoft’s support for the new Japanese Imperial era, they’ve added support for traditional Gannen writing of dates as well as the newer Ichinen style. Windows 10 now supports Gannen style Japanese dates but that support doesn’t flow through to Excel formatting. Normally the default date presentation in
Yet again, Microsoft Word is beaten by mere humans when we pit the software against words used in the 2019 Spelling Bee finals. We made a list of some words from the 2019 Spelling Bee finals including the last eight words which confirmed the winners. See for yourself how Microsoft
WhatsApp will starting showing ads in 2020 which is another reason to give up on the messaging app and move to a more private and secure but very similar app, Signal. WhatsApp has over 1.5Billion users which makes it a too tempting target for the owners Facebook and advertisers. Facebook
