XL7: Corrected Words May Be Truncated by Spelling Checker

 Last reviewed: March 27, 1997
Article ID: Q136313
7.00 WINDOWS kbtool

The information in this article applies to:

  • Microsoft Excel for Windows 95, versions 7.0

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 kbtool
Version : 7.00
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.