View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default how do you get a permanent cache?

If you use the same worksheet the following day *and* there is no break in
the data - no complete blank row - then XL will look at the previous entries
and, as soon as XL can identify what it is that you are trying to enter, it
will offer the completed entry.

I am assuming, being as you have talked about AutoComplete working on the
first day, that you have "Enable AutoComplete for all cell values" checked
in Tools Options Edit

One final thought - all bets are off if you are using XL2007 - I have no
experience of that version.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Excel Cache" wrote in message
...
Yes... Saves each day, but once you shut down the program, it erases all
cache or AutoComplete files...

"Gord Dibben" wrote:

Do you save the workbook after entering the data?


Gord

On Tue, 7 Oct 2008 12:38:13 -0700, Excel Cache
wrote:

We take care of the building's mail, and to get a device that would read
and
automatically tell the computer the name, address, city, state would
cost
thousands of dollars more... So each day, we enter it into Excel; now if
it
comes up twice per day, great - the memory of the item gets displayed,
but,
once you turn off Excel, that memory gets erased, and we would have to
enter
everything all over again...

:-(

Dan

"Gord Dibben" wrote:

Your original post stated "I'm in a mail prg."

What do you mean by that?

Are you using Excel in some manner?

If so, are you speaking of the Autocomplete feature?

Autocomplete is driven by unique entries in the same column above or
below
the entry cell.


Gord Dibben MS Excel MVP

On Tue, 7 Oct 2008 10:54:02 -0700, Excel Cache
wrote:

It is as simple as filling in a few cells, and when you start typing
the
contents of those cells again, the entire word or words show up...
This
happens now, when you leave the prg. on, once you turn it off, the
words get
erased!

Thank you!

Dan

"Jim Thomlinson" wrote:

Need more info. The definition of cach is high speed temporary
memory so your
request to make it permanet make no sense...
--
HTH...

Jim Thomlinson


"Excel Cache" wrote:

I'm in a mail prg. and I desperately need to figure out how to
make the cache
permament! Please help!