Thread
:
how do you get a permanent cache?
View Single Post
#
12
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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!
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann