Whats New In Word, Excel, PowerPoint, Outlook for 2019

I recently attended Microsoft Ignite 2018 in Florida which presented many new useful features and function for Office products. What’s New In Word, Excel, PowerPoint, Outlook Desktop LIST TO GRAPHICS Microsoft want out of its way to show of the Artificial Intelligence that is built into desktop Word, Excel, PowerPoint and Outlook.  The coolest new Office feature demonstrated at Ignite 2018 was a simple but powerful suggestion to move text lists into dynamic graphics using…

New Functions in Excel For 2019

You would not expect much new in Excel after 30 years of development but you would be wrong if you think there is nothing highly useful and new in Excel for 2019.  I recently attended Microsoft Ignite 2018 in Florida which presented many new useful features and function for Office products in 2019 but Excel was a special case.  In addition to all the common functionality explained in THIS article, Excel has some new VERY…

SOLVED: Why Is 64 Bit MS Office Now Recommended?

Microsoft has changed their guidance to state that from September 2018 on, they recommend the 64 bit version of Office be installed.  This is a departure from the 32bit guidance Microsoft provided previously. After Microsoft first compiled a 64 bit version of MS Office in June 2010, they immediately told consumers and companies not to use it.  The issue was not cost, stability or features; they were all the same as the 32 bit version. …

SOLVED: What’s The Difference Between Office 2019 & Office 365 Pro Plus

For many (most?) corporate users, Office 2019 would be a step down from what the Office 365 Pro Plus they are using now.  Office 2019 is a non-subscription based version of Office 365 ProPlus from October 2018 (yes, that is next month).  If you have Office 365 Pro Plus, you already have Office 2019. Microsoft emphatically claims that Office 2019 is the very last version of MS Office that consumers or companies will be able…

SOLVED: How To Remove Add-Ins That Are Stuck In Outlook

If you see additional icons in your Outlooks HOME ribbon and can not remove them using the normal process of FILE > OPTIONS > ADD-IN MANAGER you are likely using a hosted backend like Office 365.  In that case you can remove addins from Outlook via Outlook Web Access: Note that you can skip the first 3 steps by just clicking https://outlook.office.com/owa/?path=/options/manageapps  Surf to mail.office365.com and sign in Click the settings COG in the top right corner…

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. Please verify you have all the pre-requisites installed on your machine. The installation is unable to proceed due to missing…

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 into Office 2010 products without using add-ins: Start Word, Excel or PowerPoint 2007 or 2010 Click the INSERT tab Click…

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 ‘nickname’ cache is stored in %localappdata%\Microsoft\Outlook\RoamCache There are three easy ways to empty the Outlook Autocomplete Email Address Cache: Flush The…

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 between the two options or even set your own grammar checking details by: Start WORD Click FILE > OPTIONS >…

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 by clicking the POP OUT icon.  The question is, in the desktop version, how can Outlook be set to use…

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 like to live on the edge, like us at URTech.ca 🙂 To do this you have 3 changes to make;…

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 your START button and select APPS & FEATURES Scroll down to and click on MICROSOFT OFFICE 365 PROPLUS Click the…

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 saving files”.   This has to be set for each person, in every profile, on every machine.  That can be a…

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 enter 26594 26594 does seem like a random number and it probably is, however, Microsoft has made it possible to…