Close

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: 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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

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 […]

Read more...

SOLVED: How To Invert a Table In Excel (Swap The Columns and Rows)

If you want to invert (swap the columns for rows) using Excel 2007 through Excel 2016, you can use the TRANSPOSE function. In Excel, select all of the data you are interested in, right click select COPY Right click on an empty cell elsewhere in the same or a different worksheet Select PASTE SPECIAL > PASTE […]

Read more...

SOLVED: How Disable CONVERSATION VIEW in Office365 Webmail OWA and Outlook 2016

Conversation View was a pretty neat idea that I thought I would really like when it was released in 2013.  The idea of bringing all of the replies into a single thread in Outlook sounded great.  In practice I HATE IT because I find it much harder to find individual messages and because if you […]

Read more...

Video: SOLVED: How To Check / Release Office365 Quarantine Email Messages

If you have ever not received an email that you know was sent but did not bounce back to the sender, it might be that the backend server has marked it for deletion and put in the Quarentine.  Microsoft, and all good companies, have email filtering that saves you from the most aggressive spam.  In […]

Read more...

Video: SOLVED: How To Use Negative Search Terms In Outlook

If you want to filter out some results from a search in Outlook, you can use a ‘negative search term’.  It Outlook that negative term is NOT.  It has to be in capital letters.  That is the ‘gotcha’ that most people screw up on if they know about the use of NOT in Outlook. Filtering or […]

Read more...