Energy Lens

Energy management made easy

How to Update and Repair Excel

If an Excel add-in is acting peculiarly (or not at all), it's often because Excel is broken in some way. Updating and repairing Excel will often fix things.

Follow the steps below – first update, then repair. 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 Excel

This should be the same process as updating Windows, as Microsoft has merged the two:

  1. 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).
  2. 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).
  3. Follow through the instructions until your version of Office has been updated with all the latests patches and service packs (e.g. SP1, SP2, etc.).

Repairing Excel 2016, 2013, 2010 or 2007

The instructions for this depend on which version of Windows you're using:

Windows 10

Windows 8 / 8.1

Repair Office in Windows 10 and 8

Windows 7 and earlier

Running Detect and Repair for Excel 2003 or Excel 2002 (XP)

  1. Open Excel, and go to "Help" (at the top of the Excel window, next to "File", "Edit", "View", "Insert" etc.).
  2. Select "Detect and Repair..." (see screenshot).
  3. Make sure to select "Restore my shortcuts while repairing".
  4. Click "Start" to begin the Detect and Repair process.
Detect and Repair in Excel 2002 (XP) and 2003

© 2006–2022 BizEE Software – Contact Us | About Us | Privacy Policy