Category: Microsoft Office

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

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

Categories:   Office 365   Microsoft Office


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

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

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

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:

Categories:   Microsoft Office   Cleanup


Control automatic updates of Office 2013, 2016, 365
article #1041, updated 294 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.

Categories:   Microsoft Office   Office 365


Microsoft Office Configuration Analyzer Tool 2.2
article #1012, updated 432 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:

Categories:   Microsoft Office   Office 365


Excel falsely reports "cannot open or save any more documents because there is not enough available memory or disk space"
article #994, updated 491 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:   Microsoft Office   Office 365


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

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

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

Application.ScreenUpdating = True
Set wbCSV = Nothing
End Sub

Categories:   Microsoft Office   


Get, Set, Activate, and Do Lots More Things for Office Keys
article #717, updated 1274 days ago

To get current keys, this is excellent:

Here’s a command line which works on Microsoft Office 2013 32-bit, on a 64-bit system, to get the key identifier (last set of characters):

cscript "C:\Program Files (x86)\Microsoft Office\Office15\OSPP.VBS" /dstatus

The above can work in a CMD, even a remote CMD. The script does a lot of different things; for a list on the above system, try this, from the console only:

cscript "C:\Program Files (x86)\Microsoft Office\Office15\OSPP.VBS" 

Categories:   Microsoft Office   


When Office 2013 Crashes Due To DirectX (ATIDxx64/32.dll)
article #676, updated 1417 days ago

This is a situation in which Office 2013, either 32-bit or 64-bit, will not run on any install. The way to handle it, is to disable “hardware acceleration” by registry entry. Go here:


then create key Graphics, and then in that key a DWORD DisableHardwareAcceleration, set value to 1 for disable.

Categories:   Microsoft Office