Category: Microsoft Office

Excel: blank cell if zero
article #1447, updated 29 days ago

Use this as the cell format:

0;-0;;@

Categories:      

==============

Excel Name Manager: Ctrl-F3
article #1445, updated 36 days ago

Gets rid of all custom names, and while doing so, gets rid of a lot of external references which may prevent you from deleting Links.

Categories:      

==============

Fix Office, Outlook, 365 issues with Microsoft Support and Recovery Assistant (SaRA)
article #1316, updated 793 days ago

Excellent tool.

https://support.office.com/en-us/article/microsoft-support-and-recovery-assistant-sara-e90bb691-c2a7-4697-a94f-88836856c72f

Categories:      

==============

Remove Office activation from Windows, Office license reset
article #1241, updated 944 days ago

From the indefatigable Mike Crayton:

https://www.thecloudjournal.net/2016/08/reset-microsoft-office-product-activation-status/

https://gallery.technet.microsoft.com/office/How-To-Reset-Office-01cf9c07

This can help a lot when Office will not activate.

Categories:      

==============

Enabling disabled Office add-ins automatically
article #1274, updated 945 days ago

There is a way:

https://rakhesh.com/windows/enabling-disabled-office-add-ins-automatically/

Categories:      

==============

"AdxTaskPane" window comes up with Outlook
article #1237, updated 1134 days ago

When recent versions of Outlook and other Office applications run certain plugins, sometimes the result will come up in a separate window called “AdxTaskPane”. To prevent this:

  1. File > Options > General > User Interface options
  2. Choose “Optimize for compatibility (application restart required)”
  3. Restart the application

Categories:      

==============

When Microsoft Office won't uninstall
article #1200, updated 1213 days ago

Try step #1 here:

https://blogs.technet.microsoft.com/odsupport/2015/05/01/how-to-reset-an-office-365-install-to-the-initial-activationinstall-state/

Courtesy of the extraordinary Mike Crayton.

Categories:      

==============

Advanced Microsoft Office Repair Tool
article #1060, updated 1575 days ago

It’s called the “Microsoft Office Configuration Analyzer Tool”, or OffCAT. Courtesy of the excellent Kaleb Carrol.

https://www.microsoft.com/en-us/download/details.aspx?id=36852

Categories:      

==============

Manually remove Office 95, 97, 2000, XP, 2003, 2007, 2010, 2013, 2016
article #234, updated 1577 days ago

Microsoft-provided removal tools for Office. A new page for 2007 through 2016:

https://support.office.com/en-us/article/Uninstall-Office-from-a-PC-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8?ui=en-US&rs=en-US&ad=US

Fix-Its now exist for Office 2010, 2007, and 2003:

http://support2.microsoft.com/kb/971179

A utility for manual removal of Office versions at and before XP, is reportedly in the 2003 Office Resource Kit, confirmed available at the link below as of right now, although the installer appears to crash:

http://download.microsoft.com/download/0/e/d/0eda9ae6-f5c9-44be-98c7-ccc3016a296a/ork.exe

Categories:      

==============

Control automatic updates of Office 2013, 2016, 365
article #1041, updated 1633 days ago

This article states that it applies to click-to-run 2013 and later, which certainly includes 365. Its registry entries permit automatic updates to be turned off and on, and also, for the on-PC UI item to be turned off and on too.

https://support.microsoft.com/en-us/help/2753538/automatic-updating-for-office-2013-and-office-2016-click-to-run-is-not-enabled

Categories: