how do you get a permanent cache?

E

Excel Cache

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

Jim Thomlinson

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

Excel Cache

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
 
G

Gord Dibben

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
 
E

Excel Cache

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
 
S

Sandy Mann

thousands of dollars more... So each day, we enter it into Excel;

What do you mean by "enter it into Excel"? Are you entering the details
into a spreadsheet? If so why not just save the sheet or am I completely on
the wring track.

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
E

Excel Cache

Hmmm... I'm afraid that I explained it wrong...

We enter them into a spreadsheet, then print it, and the computer shuts down
for the day. The next day, the cache is empty, or the computer does not
'remember' the data items (names) that I put in the day before... I figure
there is some kind of cache, where the names are stored, that gets erased
when you shut the program down; what I need (and so desperately want!) is the
knowledge of this cache file, and the ability to save it when the program
shuts down!

Thanks for all of your help!

Dan
 
D

David Biddulph

So, as Sandy suggested, why don't you save as an Excel file?
The computer won't "remember". That's what the save function is for.
 
S

Sandy Mann

It sounds like you are talking about AutoComplete. This is a facility in XL
whereby as you enter data in a cell XL looks at the previous entries in the
same Column and, if it can guess what you are trying to enter, enters it for
you. This only works if there is data in an unbroken path above the cell
that you are entering the new data into. Therefore if you save the
spreadsheet and use the same sheet the next day, XL will have data to look
at.

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
E

Excel Cache

Yes... Saves each day, but once you shut down the program, it erases all
cache or AutoComplete files...
 
E

Excel Cache

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
 
S

Sandy Mann

Excel Cache said:
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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
E

Excel Cache

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
 
S

Sandy Mann

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top