| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
recently used file list
I have this problem in both Excel and Access (but not word). I can't seem to
get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
Shari
The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I talked with the administrator and he wasn't able to quickly find which keys
to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
Shari
For Excel the key is at HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options on right side screen find DefFileMRU. Change the value from (3) to (9) by right-click on the key and Modify I haven't been able to find a key for Access. As far as changing permissions................StartHelp and Support "permissions" The admin'r must make the changes to users rights. Gord On Thu, 7 Sep 2006 05:54:07 -0700, Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I use xl2003, so this version number could change for you (it's 11 in xl2003).
Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
Dave
What does changing Option5 do for me? Gord On Thu, 07 Sep 2006 10:41:43 -0500, Dave Peterson wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. Gord Dibben MS Excel MVP |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I'm not sure what bit controls this, but if I didn't change this, the checkmark
in front of the MRU option remained unchecked. (I guess that might not be a problem for the OP, though--if it was already checked.) IIRC, it went from 8c5 to 885 (hex)--with all my other options included. Gord Dibben wrote: Dave What does changing Option5 do for me? Gord On Thu, 07 Sep 2006 10:41:43 -0500, Dave Peterson wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. Gord Dibben MS Excel MVP -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
Surprisingly I was able to get into my regedit and looked for both of these
names and I don't see either one. The closest I see in Options95. There is also an MRUFuncs that has 4s in the data - I tried changing those numbers and at one point I got 5 entries in my recent file list in registry (but not in Excel). I also tried to find similar entries in Word since that works perfectly, but didn't see anything related. Thanks for all the help. "Dave Peterson" wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I am still trying to figure out how to fix this problem. I have been able to
modify my registry. Neither Option5 or DefFileMRU was in the Options settings so I added them both as DWords and changed the values to the ones below. There is still no change. I go into Excel and the recent used file list is still set to 4 and will not keep any changes. I'm ready to try the next suggestion :-) Thank you for help. "Dave Peterson" wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I don't have any other guesses. You may want to make sure that you are
authorized to make/save changes to the registry. Can you verify that you're logging on as an administrator? Shari wrote: I am still trying to figure out how to fix this problem. I have been able to modify my registry. Neither Option5 or DefFileMRU was in the Options settings so I added them both as DWords and changed the values to the ones below. There is still no change. I go into Excel and the recent used file list is still set to 4 and will not keep any changes. I'm ready to try the next suggestion :-) Thank you for help. "Dave Peterson" wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I would say that I am not authrized €“ I also dont have admin rights. But I
am able to make changes to the registry that stay. I know I can change the number of tabs on a new worksheet and that sticks. Do I need to try and get an admin to log on and change the registry that way? "Dave Peterson" wrote: I don't have any other guesses. You may want to make sure that you are authorized to make/save changes to the registry. Can you verify that you're logging on as an administrator? Shari wrote: I am still trying to figure out how to fix this problem. I have been able to modify my registry. Neither Option5 or DefFileMRU was in the Options settings so I added them both as DWords and changed the values to the ones below. There is still no change. I go into Excel and the recent used file list is still set to 4 and will not keep any changes. I'm ready to try the next suggestion :-) Thank you for help. "Dave Peterson" wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
recently used file list
I would have guessed that the earlier stuff would have worked.
I guess it couldn't hurt to have an admin try it. (I'd try editting the registry one more time, though--just in case.) Shari wrote: I would say that I am not authrized €“ I also dont have admin rights. But I am able to make changes to the registry that stay. I know I can change the number of tabs on a new worksheet and that sticks. Do I need to try and get an admin to log on and change the registry that way? "Dave Peterson" wrote: I don't have any other guesses. You may want to make sure that you are authorized to make/save changes to the registry. Can you verify that you're logging on as an administrator? Shari wrote: I am still trying to figure out how to fix this problem. I have been able to modify my registry. Neither Option5 or DefFileMRU was in the Options settings so I added them both as DWords and changed the values to the ones below. There is still no change. I go into Excel and the recent used file list is still set to 4 and will not keep any changes. I'm ready to try the next suggestion :-) Thank you for help. "Dave Peterson" wrote: I use xl2003, so this version number could change for you (it's 11 in xl2003). Close excel windows start button|run|Regedit Backup the registry before you start (and be careful). HKCU/Software/Microsoft/Office/11.0/Excel\Options change: Option5 to 885 (hexadecimal) and change: DefFileMRU to 9 (hexadecimal or decimal) Shari wrote: I talked with the administrator and he wasn't able to quickly find which keys to change. Do you know which keys needs to be updated or how to change the permissions so users have access to updating through the program? Thank you for your reply :-) "Gord Dibben" wrote: Shari The Excel and maybe Access MRU list number is stored in the Registry. Would seem you have no permission to change Registry settings. Get your admin'r to make the changes for you. Gord Dibben MS Excel MVP On Wed, 6 Sep 2006 11:23:02 -0700, Shari wrote: I have this problem in both Excel and Access (but not word). I can't seem to get the recenly used file list to stay set to 9 files. It always defaults back to 4. When the administrator is logged into the computer, this doesn't seem to be an issue, just happens when I am logged in. Any suggestions on how to fix this? Thank you. -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto updating list | Excel Worksheet Functions | |||
| Recently Used Files List | Excel Discussion (Misc queries) | |||
| Subtotals in a list | Excel Discussion (Misc queries) | |||
| how do you turn an email address list into an Excel csv or txt file? | Excel Worksheet Functions | |||
| Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Linear Mode
