File Dropdown List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Normally whenI click on the Office Button in the top right corner (after
launchinbg Excel 2007), I get a dropdown list containing a number of most
recently opened files. Every now and then (possibly as a result of a
reboot), the dropdown list disappears and I am forced to sequentially open a
number of files one-by-one (after doing a global search of files with the
extension XLSX). Am I doing something wrong or might there be a bug in the
software regarding this feature?
 
Check in your options and see how many files are set to show at startup.
Also, if you clear your history, etc it will remove the list of recently
opened files. Mine is set to automatically clear everything on startup for
security purposes.
 
Shawna:

I had set the number of files to be displayed at 17 (for some reason that I
cannot remember). I don't know how to clear my History in Excel, so I
suspect I've never done that. When you say yours is "set to automatically
clear everything on startup", do you mean at startup of Excel or do you mean
startup of your computer? If you mean startup of your computer, then that
might be what's happening inasmuch as the list seems to disappear only when I
reboot my computer. Where would this parameter be set?
 
I have a free program called CCleaner that clears everything out at startup.
I shut my computer off every night or it runs too slow. The option is in the
CCleaner program to clear recently used files at startup. You may have some
kind of program that runs at startup (reboot) that clears out your files.

You can check what runs at startup by going to Start -> Run -> type in
msconfig -> and go to startup tab. Be very careful when working in this as
it could mess up your computer if you click the wrong things. Look through
the programs in your startup tab and see if you recognize something that is a
cleaner type program. I don't know what a lot of them are called. If you
find the program just unclick the box and then apply or ok. Whatever the
option is to save and end.

You could also create a folder and keep your often used files in it so if
you have to look for them they are not far. Mine are set to go to My
Documents and I have folders in there to sort them. Hope this helps.
 
That's the explanation. I do have CCleaner on my system and I do run it
periodically. That must be what clears out the list of XL files. Thanks for
your help.
 
CCleaner will not clear your Excel MRU file list.

I use CCleaner regularly and have never had my Excel MRU list cleared.

One guess........

For Excel 2002 and 2003............

Are you running TweakUI?

If so, you may have disabled the MRU lists by unchecking "maintain document
history list" under the Explorer tab.


Gord Dibben Excel MVP
 
I'm using XL 2007 and have not knowingly run TweakUI. Further, the list
disappears sporadically, I believe only after I reboot my system (warm or
cold boot).
 
There is an option in CCleaner that you can check to clear the MRU list.
Even though I unchecked the box it still cleared my lists.
 
Back
Top