E
Excel Cache
I'm in a mail prg. and I desperately need to figure out how to make the cache
permament! Please help!
permament! Please help!
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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...
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
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
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
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
(e-mail address removed)
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
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
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
G
Gord Dibben
Do you save the workbook after entering the data?
Gord
Gord
E
Excel Cache
Yes... Saves each day, but once you shut down the program, it erases all
cache or AutoComplete files...
cache or AutoComplete files...
S
Sandy Mann
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
G
Gord Dibben
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 Tools>Options>Edit
"Enable autocomplete for cell values" checkmarked?
Gord
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 Tools>Options>Edit
"Enable autocomplete for cell values" checkmarked?
Gord
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
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
B
Ben M. Schorr - MVP (OneNote)
How many unique values are we talking about? 50? 500? 5000?
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q
E
Excel Cache
500 would be a maximum...
Ben M. Schorr - MVP (OneNote) said:How many unique values are we talking about? 50? 500? 5000?
--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com
Author - The Lawyer's Guide to Microsoft Outlook 2007:
http://tinyurl.com/5m3f5q
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
(e-mail address removed)
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
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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
"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
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.