Most Recently Used list (MRU) - Excel

[Dave Warnimont]

My Most Recently Used list (MRU) does not always list the
Most Recently Used file. Sometimes the file i just used
shows up and sometimes it doesnt. I cant find a pattern
to identfy why it lists. Basically, i would like it to
show any time i open the file. Or, at least if i save the
file. How can i understand and control this. I now have
it set to 9 Most Recently Used files.
Thanks, Dave

 

[Bernie Deitrick]

The MRU will only show those files that you open using Files | Open....

If you use a macro to open a file, or double click on a file to open it, then those won't show up.

You can use a macro to ensure that when you save the workbook, it gets put on the MRU:

Sub SaveAndPutOnMRU()
Application.DisplayAlerts = False
ActiveWorkbook.SaveAs _
Filename:=ActiveWorkbook.FullName, _
AddToMRU:=True
Application.DisplayAlerts = True
End Sub

HTH,
Bernie
Excel MVP