by Allen Wyatt
(last updated September 17, 2016)
When you start Excel, it goes through quite a few procedures to make sure that everything is running properly. If it detects an error, you may see an error message in a dialog box. Sometimes the messages you see in the dialog box are not that clear, and a few are downright cryptic.
For instance, you may see a message that says "object library not registered," and be completely lost as to what it means. In this case, it is helpful to understand how Excel works with external programs.
During part of the startup process, Excel may load any number of add-ins that provide additional functionality to your copy of Excel. Basically, these add-ins are collections of macros that perform certain tasks. Macros, in turn, can rely upon other files that contain information that helps them perform their duties. These external files are called libraries.
Excel comes with an amazing number of libraries, but not all of them are accessible at the same time. A library is only available after it has been "registered" with Excel. If the library is not registered, then Excel cannot use it and the macros in the add-in cannot use it. The result: an error message.
The best way to troubleshoot this problem is for you to determine what add-ins are being loaded when you start Excel. Examine your Excel Startup folder, and make sure you know what they are all doing. (You don't need to know what they are doing, step by step, but you should be familiar with what the add-in does, in general.)
Next, find another system that loads the same add-ins. (This should be easy to do if you work in an office, but more difficult if you are a home user.) Once you find the similar system, make sure it starts up without problem. If it does, then on the problem-free system, do the following:
Figure 1. The References dialog box.
Now, on the system that has problems, do these same steps, except in Step 3 you need to make sure that the same libraries are selected as those you wrote down. When you close the VBA Editor, restart Excel to see if the problem is still there. If it is, or if you couldn't find one of the noted libraries on the problem system, then you may need to re-register Excel completely. If so, follow these steps:
Figure 2. The Run dialog box.
"c:\Program Files\Microsoft Office\Office\Excel.exe" /regserver
When you restart Excel, the problem should have disappeared. If it didn't, then you need to figure out exactly which add-in is causing the problem. You do this by locating the add-in files in the Startup folder, and renaming them or moving them to a temporary folder. Do this one file at a time, restarting Excel after each renaming or move. When the problem disappears, you know you found the problem add-in, and you can contact the vendor to find out how to resolve the problem.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2952) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
Do you want Excel to ignore other applications that may be running on your computer? You can configure the program to do just ...Discover More
The Personal workbook is a special place used to store information and macros that you can access from all the other ...Discover More
What is a list of data, and how do you create one? Here are some guidelines you may find helpful.Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."