by Allen Wyatt
(last updated June 26, 2018)
Chrys constantly works on huge multilingual documents. When he opens a document, he often sees a warning that there are "Too Many Spelling or Grammatical Errors to Continue Displaying Them." This is a bother; he don't want to do a manual spelling check (which the warning says he can do). Chrys wants to somehow instruct Word that he wants it to display all the errors, even if there are many of them.
Part of the reason why there are so many spelling errors in your document is because Word is assuming that your prose is all in English when, in fact, you are using multiple languages. You can reduce the number of spelling errors if you format your text to use the languages appropriate to that text. In other words, format your German text as German, your French text as French, and so on. If you do this, then Word knows which spelling dictionaries to use in doing its checking.
The easiest way to do this is to create character styles for each of your languages. For instance, let's say you wanted to create a character style to be used with your German text. You would follow these steps:
Figure 1. The Create New Style from Formatting dialog box.
Figure 2. The Language dialog box.
You can repeat these steps for each of the languages you use in the document. Then, select the text you want to format and apply the appropriate character style for that language. Restart Word and open the document to see if you get the same error message.
If you still get the "too many errors" message, then other approaches will need to be taken. The message doesn't appear unless there are in excess of approximately 1,400 spelling errors in the document. This threshold is hardwired and cannot be changed. Even so, Word still does the background spelling check so that it knows how many spelling errors there are—it simply doesn't display them all "as you type" if the threshold is exceeded. Because it knows how many are there, you could use a macro to display the count, in case you are curious.
Sub HighlightSpellingErrors() Dim sMsg As String sMsg = "There are " & ActiveDocument.SpellingErrors.Count sMsg = sMsg & " spelling errors in the document." MsgBox sMsg End Sub
Unfortunately, once Word believes you've passed the 1,400 error threshold, it not only displays the error message, but it also turns off the display of spelling errors in the document. This is why, earlier, I mentioned restarting Word after applying the language-specific character styles in the document; restarting should allow the display of the spelling errors.
If you want to manually turn on the display of spelling errors, you can do so by following these steps:
Figure 3. The proofing options of the Word Options dialog box.
Another approach is to turn off spell checking for certain parts of your document. To do this, you use the same steps described earlier in creating language-specific styles. You would create a character style that has the language set to "Do Not Check Spelling or Grammar" (step 7), and you then apply that character style to portions of the document you don't want checked. The idea, again, is to get the error count under the 1,400 threshold. (Remember to restart Word or follow the earlier steps to allow checking if you think you've reduced the error count enough.)
Finally, you could use a macro to highlight all the spelling errors in a document. This approach works regardless of the number of spelling errors, but it provides only a snapshot of the errors at the time the macro is run. This means that it is not dynamic; it will not update as you add new text or as you get rid of spelling errors.
Sub HighlightSpellingErrors() Dim r As Range ' Clear existing highlighting ActiveDocument.Range.HighlightColorIndex = wdNoHighlight ' Highlight spelling errors For Each r In ActiveDocument.SpellingErrors r.HighlightColorIndex = wdYellow Next r End Sub
After running the macro, any highlighting you previously applied in your document is gone and all spelling errors are highlighted in yellow.
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (13498) applies to Microsoft Word 2007, 2010, 2013, and 2016.
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!
There are a couple of ways that various parts of a document can have spelling and grammar checking "turned off." This tip ...Discover More
When you run a spell-check on a document, you may end up seeing other things that need to be edited. Never fear; you can ...Discover More
Does Word tell you that your custom dictionary is full? It might not actually be full, but even if it is, you can add ...Discover More
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.