Tip o’ the Week 417 – Resolving aliases in bulk

This might be a very old-Microsoft culture thing, but alias names have always been a relatively big deal within the company; not an alias in the sense of a nom de plume or some alter ego, but a name curiously given to mean your login name. Before enlightenment, Microsofties were emailed simply by sending to…


February 2018 Office Update Release

The February 2018 Public Update releases for Office are now available! This month, there are 14 security updates and 22 non-security updates. All of the security and non-security updates are listed in KB article 4077965. A new version of Office 2013 Click-To-Run is available: 15.0.5007.1000 A new version of Office 2010 Click-To-Run is available: 14.0.7194.5000


February 2018 Non-Security Office Update Release

Listed below are the non-security updates we released on the Download Center and Microsoft Update. See the linked KB articles for more information.   Office 2010 Update for Microsoft PowerPoint 2010 (KB4011187) Update for Microsoft PowerPoint Viewer 2010 (KB4011191)    Office 2013 Update for Microsoft Excel 2013 (KB4011700) Update for Microsoft Office 2013 (KB4011646) Update…


Office と Windows のサービスとサポートの変更

(この記事は 2018 年 2 月 1 日に Windows for IT Pros に投稿された記事 Changes to Office and Windows servicing and support の翻訳です。最新情報については、翻訳元の記事をご参照ください。) 今回は、Windows 担当ゼネラル マネージャーを務める Bernardo Caldas、および Office 担当ゼネラル マネージャーを務める Jared Spataro の記事をご紹介します。 安全で生産的なモダン ワークスタイルを提供することは、多くの企業の皆様にとっての最重要課題であり、マイクロソフトはその支援に取り組んでいます。昨年 7 月、Office 365、Windows 10、Enterprise Mobility + Security が 1 つにまとめられた新しい製品スイートの Microsoft 365 がリリースされ、この取り組みが大きく前進しました。多くのお客様がこれらの製品のうちの 1 つまたは複数への移行を進めており、アップグレードに関連する重要事項についてのご質問がマイクロソフトに寄せられています。Windows 7 と Office 2010 の延長サポート終了まで約 2…


Windows および Office のサービシングとサポートの変更【2/3 更新】

2018年2月1日 (米国時間)、Windows および Office のサービシングおよびサポートに関する変更が発表されました。今回の発表の主なポイントは以下の4点です。 Windows 10 Semi-Annual Channel の追加サービシング期間 Office 365 ProPlus のシステム要件の変更 Office 2019 の提供とサポート期間 Windows LTSC 2018 のリリース 詳細な情報は以下をご覧ください。 Office と Windows のサービスとサポートの変更  


Lee’s Excel Troubleshooting Guide

In troubleshooting various Excel issues, I have found the following solutions to work quite often. Here are my notes in troubleshooting Excel. This was intended for current version 2016, but a lot of this information is still relevant in older versions, such as 2010/2013. If you’re using something older, upgrade already. Now for my disclaimer…


Changes to Office and Windows servicing and support

Today’s post was authored by Bernardo Caldas, General Manager for Windows, and Jared Spataro, General Manager for Office. Delivering a secure and productive modern workplace is a top priority for many of our commercial customers, and we’re committed to help. Last July, we took a big step forward in this journey with the introduction of Microsoft…


Excel: Subtract Minutes from Time

So, you have a spreadsheet and you’re trying to log time entries, say for work. You work 8:00 to 4:30 and get a half hour for lunch. How do you calculate this in Excel? 1. Create a spreadsheet, and put this in column A: 8:00:00 AM 2. Put this in Column B: 4:30:00 PM 3….


Excel VBA: Deleting a worksheet in code

I wanted to take a moment and share a little VBA in Excel that would delete a worksheet from code. Usually, you would want to use this as a part of a larger routine. To call the Sub, use this syntax: DeleteWorksheet “xxx”, False Where xxx represents the name of the worksheet, and False (or…


Excel VBA: Replacing text in a specific column with code

Another really quick code snippet to replace text in a specific column through code. Usage is simple: ReplaceTextInColumn “A”, “Hello”, “Aloha” Where “A” is the column to replace text in. Hello is the text to find, and Aloha is the text to replace Hello with (thinking warm this winter). You can extend this to add…