Not a member yet? Register now and get started.

lock and key

Sign in to your account.

Account Login

Forgot your password?

Office: Word, Excel, Outlook…  // Office Apps like Word, Excel, Visio, Outlook, Project, Powerpoint, 2003, 2007 and 2010

SOLVED: How To Silently Install the Junk Mail Reporting Tool Using Scripts

If you have tried to install the Junk Mail reporting tool using a tool like PDQ Deploy or straight  … .MSI /q you likely have found that it errors out.  If you check the logs you will see: Product: Microsoft Junk E-mail Reporting Add-in — The installation is unable to proceed due to missing dependencies. […]


SOLVED: How To Insert Video Into PowerPoint or Word 2010

It can appear that changes to Word and PowerPoint are few and far between, but there was some serious improvements made to handling embedded videos in Office 2013.  If you have Office 2007 or Office 2010 you will find inserting videos to be… not obvious. Fortunately there is an easy way to insert a video […]


SOLVED: How To Reset The Outlook Address Cache

If you are typing email addresses into your Outlook and they have gone wonky there are several things you can do but the easiest is likely just to flush the Outlook Address autocomplete cache.  In old versions of Outlook, that meant deleting the .NK2 file from %appdata%\Microsoft\Outlook however in Outlook 2016 (actually since Outlook 2010) your […]


SOLVED: Word 2016 Grammar Checker Doing Too Much

If you are finding that the ‘grammar check’ in Office products (Word, Outlook…) are pointing out more than you would like, you can adjust it.  The latest version of Office 2016 offers two Grammar settings: GRAMMER Typical grammar checking GRAMMER AND MORE Typical grammar + things like “Wordiness” and “Vague Adjectives” You can easily toggle […]


SOLVED: GPO To Set Outlook To Reply In Separate Window Instead of in the Reading Pane

One of the features Microsoft introduced into Outlook is to reply in the READING PANE rather than in a separate window.  While I appreciate that this cleans up the interface, it does make navigating into old messages while composing new messages, quite messy. In the Online version Outlook Web App OWA, you can fix this […]


SOLVED: How To Change Office365 From Deferred to Current Channel

If you have Office365 Office 2016, by default you are running a product that is 4 months old.  This is called the Deferred Channel.  For a variety of good reasons you may want to change to the Current Channel: Testing Needing a new feature Needing to eliminate a bug that has been fixed You just […]


SOLVED: Office365 Office 2016 Not Changing From Deferred to Current Channel

Office 2016 from Office365 will stay in the “Channel” it was installed with even if you change from Deferred to Current or Current to Deferred in Office365.  There are three ways to force Office365 Office 2016 to change channels and I suggest using the third one. Uninstall and Reinstall Office Repair Office Right click on […]


SOLVED: Script and GPO To Disable Backstage When Saving In Office 2016

If you want to disable Backstage View when saving in Word, Excel, PowerPoint, … you can set it with a Group Policy Object (GPO), a script or manually HOW TO DISABLE OFFICE BACKSTAGE MANUALLY: To disable the Backstage View manually, just click: FILE > OPTIONS > SAVE > and check “Don’t show the Backstage when opening or […]


SOLVED: How To Disable SHARE Button in Office 2016 Using a GPO

If you have Office 2016 and you want to block your staff from easily saving content in the cloud, you can disable the SHARE button using the following Group Policy Object (GPO): User Configuration -> Administrative Templates -> “Office Product Name” -> Disable Items in User Interface -> Custom -> Disable Commands > ENABLE and […]


SOLVED: Outlook Not Showing Presence Icons From Skype – Lync

If your Outlook is not showing the Presence Icons (Green, Red, Blue… squares beside names) there are several possible issues: UPDATED January 18 2017 – If you have Mitel MiCollab make sure you read items 1 & 5. 1 – REGISTRY POINTS TO SOMETHING OTHER THAN SKYPE – LYNC This was my issue.  I recently installed […]


SOLVED: GPO To Block Macro’s On Local PC But Not File Shares

Macros in Word, Excel and PowerPoint used to be one of the most common attack vectors but they largely died out near 2010.  In 2016 they are being used aggressively in Crypto/Ransomware attacks and you may want to disable them.  Specifically, they are often sent in email attachments. Word / Excel / PowerPoint 2013 and […]


Video: SOLVED: How To Use Flash Fill in Excel to Separate Numbers From Text

If you have messy data that includes both numbers and letters in the same cell but want to separate the numbers from the letters, you can use Flash Fill.  Flash Fill is built into Excel 2013, 2016 and presumably every future version. Flash Fill typically populates cells automatically (like and autocorrect function) but if the […]