autocomplete not working properly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The autocomplete function only references entries on the active page rather
than the whole document. If I enter "planning" in the beggining of page
one and then again at the end of the page, the autocomplete functions
properly, but if I try entering "planning" on page two, it doesn't complete
the word. I have to enter it in full, then subsequent entries on that page
only will be autocompleted. How can I set it to reference all words entered
in that column from the whole document?

(note: the function worked without a problem for the first few pages, and
then just stopped without an apparent reason.)

Does anyone else have this problem?
 
You refer to pages and documents instead of workbooks and worksheets. Are you
having this problem in Excel or Word?
 
Yes, this is in Excel. When I say pages, I mean printed pages--after
printing once, the sheet seems to indicate with a slightly heavier line the
end of each page as it will be printed.

Now that you raise this question, I am not entirely sure if my problem
always occurs after I have printed once--I have had this problem on numerous
occassions over the years.

It is only recently that the document seemed to remember the word for about
15 lines or so, then it would just "forget" that the word had already been
entered and I would have to retype it.

Other people must have this problem, have you ever heard of it? Is there
something not set properly in preferences?

Thanks,

HM
 
Back
Top