autocomplete not working properly

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?
 
G

Guest

You refer to pages and documents instead of workbooks and worksheets. Are you
having this problem in Excel or Word?
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top