View Cart

Home

About Add-ins.com

Support

Money back guarantee

Customer feedback

New Products

Upgrades

Download Purchased software

Excel Problems
& Solutions

Site search

 

INDIVIDUAL PRODUCTS:

Macro Books

Time Saving Products

Charting Products

Data Products

Analysis Products

Specialty Products

Free Products

 

PRODUCT COLLECTIONS:

Visual Basic Collection

Productivity Suite


  

How to Repair Office

If you do an upgrade to Office via a service pack (SP) release, you may find that add-ins stop working.   It can also happen on a new PC which comes with Office pre-installed (always a bad thing in our opinion). The typical error message is "error in module 1". Other error messages also happen. 

The following are the steps to take to do the repair in a way that maximizes your chance of a successful repair.  Do not skip steps.  Do not open Excel until the instructions say to do so.

  • Reboot your PC - this insures that all files are "released" so they can be replaced if necessary.
  • Go to download the Temp File Deleter. Run the different options and delete the temp files and the EXD files.
  • If you are a past customer, download the latest upgrade from our upgrades page
  • Go to Control Panel, Add/Remove Programs, and select Microsoft Office. If running Windows XP, click Change, select Repair or Re-install, and do a Repair. If you are running Vista, the option is just Repair.  Do not do a re-install - this does not fix things.  The Repair is the key step.
  • Now you can open Excel and see if the add-ins work.

If you continue to get errors, there are several solutions:

  • If you are uncertain if you have run SP1 and SP2 if using Excel 2003, go to the Microsoft site and run these upgrades.  We have found that users sometimes do SP3 only.  It does not check to see if SP1 and SP2 are installed.  Usually if SP1 and SP2 are not installed but SP3 is installed, the errors are very nasty sounding - missing files, errors in strange files, etc.   The following are the links to the service packs.  If the link has changed, please let us know:
  • If one of our products, let us know.  We will work with you to fix
  • If another vendor's products, ask them if they have an upgrade to the product you purchased.
  • If all else fails you will need to re-install Office.  Do it the following way:
    • Reboot,
    • Un-install Office,
    • Reboot again (this finishes the un-install),
    • Download the Temp File Deleter. Run the different options and delete the temp files and the EXD files.
    • Re-install Office. 
    • Immediately do a repair of Office.  Then test to see if Excel and add-ins work. 
    • Install each SP release (1, then 2, then 3), testing and repairing per the above after each SP release.

 
Copyright 2008 Add-ins.com LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of Add-ins.com LLC.
Microsoft and Excel are trademarks or registered trademarks of Microsoft Corporation.