Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Delete recent files (2003)

    How to delete items from the list of recently-used files?

    Problem is that I have opened two versions of a file -- one is current and one is backup on a spare disk. The backup version appears first on the list of recent files, and I sometimes open it inadvertently. Of course, hovering the mouse over the file name shows the full path, but I would like to permanently delete the name from the list to prevent future accidents.

    Thx
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delete recent files (2003)

    As far as I know, there is no way to delete items from the recently used files list from within Excel itself, except by turning "Recently used files" off, then on again in the General tab of Tools | Options..., but then the entire list will be cleared. To delete an individual item, you must edit the registry. The usual dire warnings about editing the Registry apply, but nothing serious can go wrong here.
    The list is stored under the HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelR ecent Files key. The file names are in the right hand pane of RegEdit. You can delete an item by selecting it and pressing Delete, or pointing to Edit | Delete...

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete recent files (2003)

    Deleting one file from the list wil probably require editing the registry. However, if you want to delete all of the files from the list, then:

    1- Select Options from the Tools menu.

    2- Click on the General Tab.

    3- Remove the check mark from in front of the Recently used file list.

    4- Close the dialog box and exit from Excel.

    5- Open Excel again, Select Options from the Tools menu, and recheck the Recently used file list item.

    The list should now be empty.
    Legare Coleman

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete recent files (2003)

    Thanks, Hans. Worked well.
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

  5. #5
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Delete recent files (2003)

    Hans,

    "As far as I know, there is no way to delete items from the recently used files list from within Excel itself"

    Unless I have misinterpreted something....

    '---------------------------------------------------------------
    'Provides the index number and name of the most recently used files
    Sub GetNamesFromMru()
    Dim strName As String
    Dim i As Long

    For i = 1 To Application.RecentFiles.Count
    strName = strName & "Index " & Application.RecentFiles(i).Index & _
    " " & Application.RecentFiles(i).Name & vbCr
    Next 'i
    MsgBox strName
    End Sub

    'Deletes the specified file from the most recently used list of files
    Sub RemoveNameFromMru()
    Application.RecentFiles(1).Delete
    End Sub
    '--------------------------------------------

    If anybody is interested, I have some code for the MRU list that removes any deleted files and
    adds any open workbooks that are not on the MRU list (nice for Xl 97).
    I have the code permanently installed on my XL 97 / XL 2002 system

    Regards,
    Jim Cone
    San Francisco, CA

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Delete recent files (2003)

    Thanks! I wasn't aware of that; it's much more convenient than editing the registry.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    632
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Delete recent files (2003)

    Thanks for the tip. Amazing what is in those Object models when you start digging...
    --------------------------------------------------
    Jack MacDonald
    Vancouver, Canada

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •