I deleted an add-in that I was evaluating, and now every time I open Excel I get an error message. How do I stop this from happening?
	Can I check the spelling on my worksheet with one quick command?
	How can I add names to the dictionary in Excel?
	How can I check the spelling of a single word in Excel?
	How do I load Add-Ins?

I deleted an add-in that I was evaluating, and now every time I open Excel I get an error message that says Cannot find 'C:\MSOFFICE\EXCEL\LIBRARY\MyAddIn.xla'. How do I stop this from happening?
Keywords: Add-ins, Errors
Posted December 17, 1996

Once the error message comes up, just click the OK button and it Excel will continue to open. Once Excel is open, choose Tools - Add-Ins from the menu. Find the name of the add-in that you deleted and place a check mark in the box beside it. Excel will immediately respond with a message saying that it can't find the add-in and ask you if you want to remove it from the list. Choose yes and it will be removed from the list. This will also stop the error from occurring on startup.

Can I check the spelling on my worksheet with one quick command?
Keywords: Check Spelling Command
Posted January 18, 1996

When you use the Spelling command, Excel compares each word in your range or worksheet with those in its standard dictionary. If Excel does not find the word, it displays the Spelling dialog box.

To check the spelling:

1. Select the range you want to check or leave only the current cell selected to check the entire worksheet
2. From the menu bar choose Tools - Spelling command

If Excel finds a word that is not in any open dictionary, the Spelling dialog box appears. If the Always Suggest option is turned on, Excel will suggest a new word. Click on the appropriate command button.

If you began checking the worksheet with a cell that was not at the beginning, when Excel reaches the end of the worksheet, it will ask you if you would like to continue the check from the beginning. To avoid this, before activating the Spelling command, make cell A1 active. The Spelling command will then begin its check at the beginning of your worksheet. To do this easily choose Ctrl+Home, or F5 (Goto) and then A1.

Shortcut: Use F7 or click on the Spelling tool on the Standard toolbar to activate the Spelling command.

How can I add names to the dictionary in Excel?
Keywords: Add Names Dictionary
Posted January 18, 1996

You can add to the default custom dictionary words of people and companies you use frequently but Excel would not recognize. To create a custom dictionary, from the menu bar choose Tools - Spelling to display the Spelling dialog box. There needs to be at least one word the Spelling feature does not recognize. Otherwise the Spelling dialog box will not appear.

In the Add Words to edit box, enter the name for the new dictionary. Press Enter. Excel will prompt you as to whether you want to create a new dictionary. Click Yes to create the dictionary. Continue with the spell check or cancel to return to the worksheet.

You can create as many dictionaries as you need. However, you can only use one custom dictionary at a time.

How can I check the spelling of a single word in Excel?
Keywords: Check Spelling Single Word
Posted January 18, 1996

When you use the Spelling command, Excel compares each word indicated with those in its standard dictionary. If Excel does not find the word, it displays the Spelling dialog box.

To check the spelling of a single word in a cell:

1. Select a single cell
2. Select a single word by activating the formula bar and using the mouse or keyboard to select the word (if In-Cell Editing is turned on you can double-click or press F2 and select the word right in the cell)
3. From the menu bar choose Tools - Spelling

If Excel cannot find the word in any open dictionary, it displays the Spelling dialog box. Select the appropriate options from the dialog box. If Excel determines the word is spelled correctly, it displays a message to that effect.

Hint: F7 will also activate the spell checker.

How do I load Add-Ins?
Keywords: Load Add-Ins
Posted January 16, 1996

To load one or more Excel Add-In programs, select Tools - Add-Ins. The Add-Ins Available list shows the installed add-ins, including those that were installed when you installed Excel. Add-Ins with a check mark beside them are currently loaded. To activate an add-in, click on it, or highlight it and press the space bar. The displayed add-ins include those found in the /Excel/Library folder. To add a new add-in to your list, select the Browse button to show the browse dialog box, navigate to where the new add-in is located, choose the add-in (xla), and click OK. When you have activated all the add-ins you need, select OK to return to the worksheet. Excel will then load the add-ins you've selected.

Back to Top

Back to the FAQ Table of Contents

Happiness is positive cash flow.