XL7: Corrected Words May Be Truncated by Spelling Checker

ID: Q136313

7.00 WINDOWS kbtool

The information in this article applies to:

SYMPTOMS

In Microsoft Excel, words that are corrected by the spelling checker may be truncated by one character. For example, if multiple cells in a worksheet contain the following

   outstnading

and you correct all of the words to "outstanding" by clicking the Change All button in the Spelling dialog box, most or all of the words may appear like this

   outstandin

rather than as "outstanding" (the correct spelling).

CAUSE

This problem occurs because of a problem in the MSSP232.DLL spelling file. The design of the DLL may cause a single character to be truncated from a word when the word is corrected by the spelling checker.

WORKAROUND

To avoid the problem, do not use the Change All button when you check spelling in a worksheet. Instead, use the Change button to correct one misspelled word at a time.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0a.

MORE INFORMATION

When this problem occurs, it will usually only affect the second and subsequent instances of a misspelled word within a document. The first corrected instance of the word will appear correctly. For example, if you have a worksheet that contains the following misspelled words:

   outstnading
   outstnading
   outstnading
   outstnading
   outstnading
   outstnading

If you run the spelling checker by clicking Spelling on the Tools menu, and you then click the Change All button to correct all of the misspelled words to "outstanding," you the result will resemble the following:

   outstanding
   outstandin
   outstandin
   outstandin
   outstandin
   outstandin

KBCategory: kbtool kbfixlist KBSubcategory:

Additional reference words: 7.0 7.00 spellchecker spelling checker

Keywords          : kbfixlist
Version           : 7.00
Platform          : WINDOWS

Last Reviewed: March 29, 1997