| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do you get a permanent cache?
I'm in a mail prg. and I desperately need to figure out how to make the cache
permament! Please help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent 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 "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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent 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 "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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
Excel Cache" wrote in message
... 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 Replace @mailinator.com with @tiscali.co.uk |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent 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 "Sandy Mann" wrote: Excel Cache" wrote in message ... 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 Replace @mailinator.com with @tiscali.co.uk |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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. -- David Biddulph "Excel Cache" wrote in message ... 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 "Sandy Mann" wrote: Excel Cache" wrote in message ... 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 Replace @mailinator.com with @tiscali.co.uk |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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 Replace @mailinator.com with @tiscali.co.uk "Excel Cache" wrote in message ... 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! |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent 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 "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! |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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 "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! |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
500 would be a maximum...
"Ben M. Schorr - MVP (OneNote)" wrote: 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 "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! |
|
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
"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! |
|
#18
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent 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 "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! |
|
#19
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do you get a permanent cache?
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Pivot Table cache | Excel Discussion (Misc queries) | |||
| Excel 2007: Pivot sharing same cache? | Excel Discussion (Misc queries) | |||
| Excel cache appliance | Excel Discussion (Misc queries) | |||
| Pivot Cache - Massive Spreadsheet | Excel Discussion (Misc queries) | |||
| Pivot cache | Excel Discussion (Misc queries) | |||
Linear Mode
