
Click "Start" to begin the Detect and Repair process.The command line can be written to a batch file and save to a common drive so it can be used for remote computers or in a domain environment, the hostname of the computer must be collected in order to identify the output data to which computer it came from. Make sure to select "Restore my shortcuts while repairing".
Select "Detect and Repair." ( see screenshot). Open Excel, and go to "Help" (at the top of the Excel window, next to "File", "Edit", "View", "Insert" etc.). Running Detect and Repair for Excel 2003 or Excel 2002 (XP)
A window containing a list of your installed programs should appear.
Double click on "Programs and Features" (or "Add or Remove Programs" on Windows XP). The "Control Panel" window should appear. Right-click on the Windows "start" menu (bottom-left corner of your screen). Repair Office in Windows 10 or 8 Windows 7 and earlier The "Programs and Features" window containing a list of your installed programs should appear. (If you don't have the Windows 8.1 update, hover the cursor in the bottom-left corner of the screen until a small image of the "start" screen appears, then right-click on the icon.) Right-click on the Windows "start" icon (bottom-left corner of your screen) to open the "Start Context Menu". Choose from "Quick Repair" or "Online Repair". Select "Microsoft Office" (or "Microsoft Excel" if you do not have the full Office installation). The "Apps and Features" window containing a list of your installed programs should appear. The "Windows Settings" window should appear. Click on the Windows "start" icon (bottom-left corner of your screen). The instructions for this depend on which version of Windows you're using: Windows 10 Follow through the instructions until your version of Office has been updated with all the latests patches and service packs (e.g. Visit the Microsoft Update page for instructions on how to run Windows update on your particular machine (typically via "Windows Update" in the Windows Control Panel). Make sure that Excel is closed (ideally you will have rebooted your computer so that Excel hasn't even been opened yet in your current Windows session).
This should be the same process as updating Windows, as Microsoft has merged the two: It's best to reboot your computer before starting an update or repair, to reduce the chances of a running program preventing files from being repaired or replaced. Updating and repairing Excel will often fix things.įollow the steps below – first update, then repair. If an Excel add-in is acting peculiarly (or not at all), it's often because Excel is broken in some way.