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!