Forum Discussion

Copper Contributor

Oct 09, 2017

How can a remove these files from the 'Recent' list?

How can a remove these files from the 'Recent' list please? I've deleted these workbooks from OneDrive, but they still appear in the Recent list. How can I stop them appearing every tim...

excel

Tim Shiles

Copper Contributor

Oct 09, 2017

Thanks Guy. That gets rid of them, but then I can't see any recent workbooks. I want to be able to see some, just not those that no longer exist.

SergeiBaklan

Diamond Contributor

Oct 09, 2017

Right click -> Remove from list shall work

Tim Shiles
Copper Contributor
Oct 09, 2017
Thanks Sergei. I've tried that: no luck!
- SergeiBaklan
  Diamond Contributor
  Oct 09, 2017
  Tim,
  
  Strange. Just tested - created new workbook, saved it on my OneDrive. Closed Excel, opened again, in backstage in Recent remove that file from the list. Closed and opened again - no this file in the list.
  
  Will it work in your environment with new file if you repeat? Are old files pinned?
  - Tim Shiles
    Copper Contributor
    Oct 09, 2017
    Hi Sergei. This has been solved by a user on another forum. I ran this code:
    
    Sub Clear_Dead_Files()
    Dim i As Long
    On Error Resume Next
    OriginalMax = Application.RecentFiles.Maximum
    Application.RecentFiles.Maximum = 50
    For i = Application.RecentFiles.Count To 1 Step -1
        If Dir(Application.RecentFiles(i).Name) = "" Then
            Application.RecentFiles(i).Delete
        End If
    Next
    Application.RecentFiles.Maximum = OriginalMax
    End Sub