Knowledge Base

XL7: Corrected Words May Be Truncated by Spelling Checker

PSS ID Number: 136313

Article Last Modified on 10/22/2000


The information in this article applies to:


This article was previously published under Q136313

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


Additional query words: 7.0 spellchecker spelling checker

Keywords: KB136313
Technology: kbExcel95 kbExcel95Search kbExcelSearch kbExcelWinSearch