Disappearing AutoText Entries

by Allen Wyatt
(last updated February 21, 2008)

5

Recently subscriber Chuck Swett complained that it appeared his AutoText entries were disappearing in Word 2000, and he wondered why this was happening. Different subscribers provided different possible answers. For instance, Chuck could be working on a network which didn't allow the Normal.dot file to be saved, or perhaps Chuck was saving AutoText entries is a different template that wasn't always available.

However, Chuck gave one telling piece of the puzzle when he indicated that he frequently switches back and forth between Spanish and English in his documents. According to other subscribers, this problem is only encountered when switching from one language to another. It appears that Word 2000 maintains separate AutoText and AutoCorrect entries for different languages; when you switch from one language to the other, only those entries for that language are available. Whether this is a bug or not is open to debate, but it is tangentially addressed in Knowledge Base article Q220247, where Microsoft indicates that AutoComplete tips--based on AutoText--do not appear when switching from one language to another. Only time will tell how Microsoft will address this issue in future releases.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1564) applies to Microsoft Word 2000.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Combining Numbers and Text in a Cell

There are times when it can be beneficial to combine both numbers and text in the same cell. This can be easily done ...

Discover More

Dynamic Data Based on Chart Changes

Change the data on which a chart is based and Excel obligingly updates the chart to reflect the change. What if you want ...

Discover More

Cross-Referencing Index Entries

You've probably seen an index where an entry says something like 'Obsidian: See igneous rock.' This sort of ...

Discover More

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!

More WordTips (menu)

Adding an AutoText Entry

Creating custom AutoText entries is not only extremely helpful, but very easy. This tip explains how.

Discover More

Restoring or Recreating AutoText Entries

When you first install Word, it includes a number of pre-defined AutoText entries. If you delete any of these entries ...

Discover More

Renaming an AutoText Entry

There are a couple of ways that you can rename an existing AutoText entry. This tip describes the techniques you can use, ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is nine minus 5?

2018-09-04 04:33:12

Ivan

Alex, many thanks for the explanation.


2018-09-04 02:58:58

Alex B

@Ivan, it seems be just a coincidence. You have 2019 in Cell A1. Date(2019,1,1) is Tuesday 01/01/2019 which is week day 3.
Internally Excel stores dates as a number and 01/01/2019 is represented by 43466.
When you omit the Date function, excel is now taking the 2019 as being the numeric representation of the date and translates it as being 11/07/1905. This also happens to be a Tuesday. This is why you are getting a 3 in both instances.
There are a number of years for which this just happens to be the case (including the years 2017-2020). Pick years outside of that range and you will find your weekday formula with and without the date function will differ.


2018-09-03 05:43:54

Ivan

Hi. I am new to this. I tested this formula =DATE(A1,1,1)-WEEKDAY(DATE(A1,1,1)-1), but I omitted Date function and used WEEKDAY(A1)-1. The formula resulted in 12/28/2018, though both =WEEKDAY(DATE(A1,1,1)) and =WEEKDAY(A1) return 3 when tested separately. Can someone exlpain why please.


2018-09-01 09:38:32

Brian

Very clever & efficient approach! Thanks for the tip.


2018-09-01 08:34:39

Alex B

If you set the Weekday return type to 2 for Mon =1 through to Sun =7, you get a slightly shorter formula.
=DATE(A1,1,1+7*B1-WEEKDAY(DATE(A1,1,1),2))


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.