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 fixing Microsoft Office. Keys to fixing Excel are:
- Doing the multiple reboots as instructed. A royal pain, but essential.
- Run the Temp File Deleter, all options, multiple times, as instructed.
- After rebooting, never open Excel until instructed or any other Office program until done. Opening Outlook to do a quick check of your mail during the process will screw up the fixes. The same goes for Power Point to fix a presentation, etc. Office programs use common files. Opening any part of the Office Suite may prevent the steps from working.
- Do the repair of Excel last. Do not skip it.
If the message you are getting is an out of memory error or not enough resources, then either you do not have enough memory on your PC, you are running too many programs, multiple instances of Excel, or have many COM or VBA add-ins installed. See memory problems for how to fix.
REPAIR STEPS BY EXCEL VERSION
Excel 2007 Users:
- Close Excel
- Reboot and then run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
- Install the latest service pack, SP3. Service Pack 2 (SP2) for Office 2007. Do from this link. Do not Open Excel.
- Reboot and run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
- Do a Repair of Excel:
- Re-open Excel for the first time
- 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
- Reboot and then run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
- Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2003
- Reboot and run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
- Do a repair of Excel:
- 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
- Reboot and then run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
- Install the latest service pack, SP3. Service Pack 3 (SP3) for Office XP (2002)
- Reboot and run the Temp File Deleter again, all options. Do not open Excel before running the Temp File Deleter again.
- Do a repair of Excel:
- 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
- Reboot and then run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
- Install the latest service pack, SP3. Service Pack 3 (SP3) for Office 2000.
- Reboot and run the Temp File Deleter again, all options. Do not open Excel.
- Do a repair of Excel:
- Select Control Panel, Add/Remove Programs
- Select Microsoft Office 2000
- Select the repair option (not a re-install)
Excel 97 Users:
- Close Excel
- Reboot and then run the Temp File Deleter, all options. Do not open Excel or any Office program until instructed.
- Install the latest service pack, SR-2b. Service Pack 2b (SR-2b) for Office 97
- Reboot and run the Temp File Deleter again, all options. Do not open Excel.
- Do a repair of Excel:
- Select Control Panel, Add/Remove Programs
- Select Microsoft Office 97
- Do a repair of Office 97 (not a re-install
If the above fails, re-install of Office. To maximize your chance of success, do it this way:
- Make certain you have your CDs and license keys before doing these steps.
- Reboot
- Go to Control Panel, Select Office and un-install Office (do not re-open any part of Office after the reboot).
- Reboot again (this finishes the un-install).
- Run the Temp File Deleter. Run all the options. Run after the reboot.
- Re-install Office. Do not open Excel, Outlook, or any part of Office when done.
- Reboot again and run the Temp File Deleter a second time. Run all options.
- Do not open Excel or any part of Office. Install the latest service pack per above instructions. (it was removed when Office was removed)..
- Reboot again. Do not open Excel or any part of Office. Run the Temp File Deleter a third time. Run all options.
- Open Excel. for the first time and immediately do a repair of Excel (per instructions above).
- Close Excel.
- Re-install the add-ins.
- Open Excel and see if the add-ins work.
- If the add-ins still do not work, reboot again and run the Temp File Deleter a third time. Run all options.
- Run Windows Update. This will see if Microsoft has released any special fixes for Office and Excel that are needed on your PC.
- See if the add-ins work.
If the above does not solve:
- If one of our products, let us know. We will work with you to fix even though it is an Office problem. We can connect, with your permission, to your PC and hopefully 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.
|
|
|
