Category: Microsoft Office

Remove Office activation from Windows, Office license reset
article #1241, updated 35 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 36 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 225 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 304 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 666 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 668 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 724 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:      

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

Microsoft Office Configuration Analyzer Tool 2.2
article #1012, updated 863 days ago

Something very like a best practices analyzer / BPA for Office, 32-bit and 64-bit, versions 2007 and newer, both MSI and click-to-run:

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

Categories:      

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

Excel falsely reports "cannot open or save any more documents because there is not enough available memory or disk space"
article #994, updated 921 days ago

There are many situations in which a recent version of Excel will report that there is not enough available memory or disk space, where there very clearly is. To knock this one out, go to File menu and Options, click Trust Center on the left, click Trust Center Settings… on the right, and then Protected View on the left. Uncheck everything in there, and OK all the way out. Close Excel and try it again. Problem eliminated.

Categories:      

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

Import Multiple CSVs to Tabs in One Excel Spreadsheet
article #763, updated 1596 days ago

From the excellent Jerry Beaucaire; VBA, for use inside an Excel module.

https://sites.google.com/a/madrocketscientist.com/jerrybeaucaires-excelassistant/merge-functions/csvs-to-sheets

Sub ImportCSVs()
'Author:    Jerry Beaucaire
'Date:      8/16/2010
'Summary:   Import all CSV files from a folder into separate sheets
'           named for the CSV filenames
'
'Update:    2/8/2013   Macro replaces existing sheets if they already exist in master workbook
'Modded:    12/10/14   Minor edits (Jonathan Brickman)

Dim fPath       As String
Dim fCSV        As String
Dim SheetName   As String
Dim wbCSV       As Workbook
Dim wbMST       As Workbook

Set wbMST = ThisWorkbook
fPath = "X:\PATH-TO-CSVs\"       'path to CSV files, include the final \
Application.ScreenUpdating = False  'speed up macro
Application.DisplayAlerts = False   'no error messages, take default answers
fCSV = Dir(fPath & "*.csv")         'start the CSV file listing

    On Error Resume Next
    Do While Len(fCSV) > 0
        SheetName = Left(fCSV, Len(fCSV) - 4)   ' Trim .CSV from filename, make sheet name
        Set wbCSV = Workbooks.Open(fPath & fCSV)                    'open a CSV file
        wbMST.Sheets(ActiveSheet.Name).Delete                       'avoid replication, delete sheet
        ActiveSheet.Move After:=wbMST.Sheets(wbMST.Sheets.Count)    'move new sheet into Mstr
        ActiveSheet.Name = SheetName
        Columns.AutoFit             		'clean up display
        fCSV = Dir                  		'ready next CSV
    Loop

Application.ScreenUpdating = True
Set wbCSV = Nothing
End Sub

Categories: