View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default Clear the file open file name dropdown list

Hi Daniel

So, if you change the default File location to an empty folder, close Excel,
then open Excel again, are you saying that it still shows those files when
you go to FileOpen?

--
Regards
Roger Govier

"Daniel.C" wrote in message
...
Thanks, Roger, but it still doesn't work. The files don't exist any more .
Recreating them is of no use either. I can't find them in the registry,
too.

Daniel
Roger Govier a écrit :
Hi Daniel
When you use FileOpen, it will show the files as in the folder that has
been set under ToolsOptionsGeneralDefault File location.

The only way to clear the list would be
1. Set the location to be a new blank folder
2. Navigate to the existing folder using My ComputerDelete the files
that are there ( ONLY IF you are sure you don't need them any more).