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.

"CeeBee" wrote:

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?

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?

"Shawna" wrote:

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.

"CeeBee" wrote:

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?

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.

"CeeBee" wrote:

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?

"Shawna" wrote:

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.

"CeeBee" wrote:

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?

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.

"Shawna" wrote:

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.

"CeeBee" wrote:

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?

"Shawna" wrote:

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.

"CeeBee" wrote:

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?

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



On Fri, 20 Jul 2007 19:32:02 -0700, CeeBee
wrote:

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.

"Shawna" wrote:

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.

"CeeBee" wrote:

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?

"Shawna" wrote:

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.

"CeeBee" wrote:

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?