There is *NO* Autocomplete file to be deleted. As Gord says if you have
"Enable Autocomplete for cell values" ticked then Autocomplete just uses the
previous entries in the same column as its data source.

If your file is not XL2007 and not confidential then you can send me a copy
if you wish. Change my email address signature by replacing the part after
the @ sign.


--
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
...
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!