Troubleshooting Microsoft Excel
Excel has no normal.dot file like Microsoft Word, so
troubleshooting it generally takes steps that are a little more difficult right
from the start, but there's only a few things that could be wrong.
If all your applications are acting up, then you should probably
clean up your hard drive
Files Won't Open
This is often caused by one stupid setting. It's under ToolsŕOptions,
General tab. Make sure that Ignore Other Applications is not checked.
First, if Excel appears to be trying to open a bunch of files
when you launch it, check out the
information about the
XLStart folder. You may not need to come back to this article.
What the heck is an XLB file? It's where all your toolbar
customization is stored. Sometimes, it becomes corrupt, and hoses up your Excel
so that you can't use it. So, with Excel closed, you do a search for *.xlb files
and you rename or delete them. Then relaunch Excel.
Dump the Excel Windows Registry Key
There are many people who would rather that I didn't tell you
how to do this. But any adult that's paying any attention can follow my steps.
What we're doing is removing Excel from the Windows registry. When you launch
Excel again, it will re-register itself, so you can expect it to take a little
longer to launch than usual.
Hit StartŕRun and type regedit and
hit enter. Browse, just like you would in Windows Explorer or My Computer, to
the following folder:
X.X will be as follows, depending on your version of Word:
Excel 2000 is 9.0
Excel 2002/XP is 10.0
Excel 2003 is 11.0
Once you find it, right click the Excel folder, and choose
Rename. Rename it to OldExcel. This is a quickie method of backing up your
registry. Close the Registry Editor.
OfficeArtilces.com debuted on May 26, 2005.
MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures
for illustration only, without warranty either expressed or implied, including
but not limited to the implied warranties of merchantability and/or fitness for
a particular purpose. The Formulas, Functions and Visual Basic procedures on
this web site are provided "as is" and we do not guarantee that they can be used
in all situations.
Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered
trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.
All contents © 1998-2014 by MrExcel Consulting | All rights reserved