When I am typing on it one morning, it holds the cells, and autocompletes
when I need it to. It's just that once I turn the spreadseet off, all cells
that were in autocomplete are deleted...

Dan


"Sandy Mann" wrote:

"Excel Cache" wrote in message
...
Yes, it is checked, and it works fine, as long as I have the program on...
If
I shut down Excel, all the saved words are gone.

Do you have a blank Row between one day's data and the next? If so then
that will cause Autocomplete to stop working. Autocomplete looks up the
Column of data in the used range for a possiple match but will stop a a
complete blank Row and will not look any further. Excel does *NOT* hold the
words in memory.

--
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, it is checked, and it works fine, as long as I have the program on...
If
I shut down Excel, all the saved words are gone. I tried hitting Alt+F11,
and
trying to do something with Visual Basic, all to no avail... I am sure the
proper code would make this work!

Does Excel just hold all of the words in memory? Is there any way I could
get that memory to write itself on to a disk? I believe this is what you
need
to do... Another way is that I could work with Visual Basic and try to do
it
that way...

Thanks for all your help!

Dan

"Gord Dibben" wrote:

There are no such things as "autocomplete files" or a cache for Excel.
Please read the replies you have received regarding autocomplete.
Or look up autocomplete in help.
When re-starting Excel and re-opening the workbook is ToolsOptionsEdit
"Enable autocomplete for cell values" checkmarked?


Gord

On Wed, 8 Oct 2008 08:12:17 -0700, Excel Cache
wrote:

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!