How to Repair Microsoft Excel
What to do if Excel add-ins do not run
If you are getting error messages like "error in module 1", "unspecified error", or "undefined reference" , the problem is not with our add-ins! It is a problem with the installation of Office. The following are the steps to take to do the fix this problem by repairing Microsoft Office
Quick Fixes:
- Before doing any quick fix:
- Reboot your PC - this insures that all files are "released" so they can be replaced if necessary.
- Download the Temp File Deleter. Run the different options and delete the temp files and the EXD files.
- Quick Fix 1: If you are using one of our products, install the latest upgrade.
- Quick Fix 2: Do just a repair of Office. The instructions vary per version of Office, and can be found below.
- Quick Fix 3: Remove any un-needed add-ins:
- Excel 97-2003: Select Tools, Add-ins
- Excel 2007: Office Button, Excel Options, Add-ins, Manage Add-ins, Go
- Un-check any add-ins you do not need, you do not recognize, and (especially) any whose name is blank. If told an add-in does not exist, agree to its removal.
- Keep the add-ins.com add-in manager checked.
- Quick Fix 4: Install the latest Service Pack and then do a repair of Office. Do not skip the repair!
- Excel 2007 can follow the instructions per the notes below to do the service pack installs
- For Excel 2003 users can select in Excel the Help menu, and then "Check for updates"
- Excel 97-2002, including XP can find the latest service pack links below.
What to do if the above quick fixes do not fix (which is likely about 70% of the time):
- Reboot your PC - this insures that all files are "released" so they can be replaced if necessary.
- Download the Temp File Deleter. Run the different options and delete the temp files and the EXD files.
Do the above steps again even if you did them in the quick fix steps. The next set of steps are dependent on the version of Excel you have. If you have multiple versions of Excel installed, always do the steps for the oldest version of Excel first.
Excel 2007 Users:
- Open Excel
- Click on the Office button
- Click the button "Excel Options" at the bottom of the dialog
- On the next dialog click on Resources
- Click the button to the right of "get updates that is titled "Check for Upgrades". This will install SP1 (service pack 1) for Excel 2007 and any other upgrades from Microsoft. Close Excel as soon as the Microsoft Update page appears.
- Re-open Excel
- Click the Office Button, Excel Options, and Resources again
- To the right of "run Microsoft Office Diagnostics", click the button "Diagnose".
- If Office advises that Diagnostics were recently run, click the button "Run Diagnostics Again". Installing any service pack or upgrade almost always causes bugs in Office. Even though Diagnostics may report that no problems were found, it will find and fix some problems (we've seen it happen).
- If a description of why you should run Diagnostics appears, click the Continue button
- Close the Resources dialog and Excel as soon as a Microsoft Office Diagnostics screen appears. This will not close the Diagnostics screen. Then click the Run Diagnostics button. If a choice of diagnostics to be run is given, select all of them.
Excel 2003 Users:
- Close Excel
- Install each of the following service packs in order, even if you have installed SP3. They are all needed.
Unless you are 100% positive that SP1 and SP2
have been installed, install them and then re-install
SP3 even if it has been installed. It corrects some mistakes from SP1 and SP2. But it does not install all the patches that SP1 and SP2 install.
- Open Excel
- Select Help, Detect and Repair.
- A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
- Click the start button on this dialog. Even though repair may report that no problems were found, it will find and fix some problems (we've seen it happen).
Excel XP (2002) Users:
- Close Excel
- Install each of the following service packs in order, even if you have installed SP3. They are all needed. Unless you are 100% positive that SP1 and SP2 have been installed, install them and then re-install SP3 even if it has been installed. It corrects some mistakes from SP1 and SP2. But it does not install all the patches that SP1 and SP2 install.
- Open Excel
- Select Help, Detect and Repair.
- A dialog will appear with an option to restore your shortcuts. Make certain it is checked.
- Click the start button on this dialog. Even though repair may report that no problems were found, it will find and fix some problems (we've seen it happen).
Excel 2000 Users:
- Close Excel
- Install each of the following service packs in order, even if you have installed SP3. They are all needed.
Unless you are 100% positive that SP1 and SP2
have been installed, install them and then re-install
SP3 even if it has been installed. It corrects some mistakes from SP1 and SP2. But it does not install all the patches that SP1 and SP2 install.
- Select Control Panel, Add/Remove Programs
- Select Microsoft Office 2000
- Do a repair of Office 2000 (not a re-install)
Excel 97 Users:
- Close Excel
- Install each of the following service packs in order:
- Select Control Panel, Add/Remove Programs
- Select Microsoft Office 97
- Do a repair of Office 97 (not a re-install)
If all the above fails, try a re-install of Office. To maximize your chance of success, do it this way:
- Reboot,
- Go to Control Panel, Select Office and 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. You may be asked for your CDs and license key, so have them handy.
- Immediately do a repair of Office. Then test to see if Excel and add-ins work. You will have to re-install the add-ins.
- Install each SP release (1, then 2, then 3), testing and repairing after each SP release. It may be that an SP release is causing the problem.
If the above does not solve:
- If one of our products, let us know. We will work with you to fix. We can connect, with your permission, to your PC and determine the cause and hopefully fix.
- If the problem is caused by another vendor's products, ask them if they have an upgrade to the product you purchased.
|
|
|
