How to sort by "date modified" in Available Files list within Document Recovery

It happens quite often that the computer will do an automatic update or something and will shut down. I might have Excel docs open that have not been named. But it will show a list of Available Files along the left side of my Excel screen. Now, I have a problem in that this is a really large list that has accumulated over time. Some 'available files' go back two years! I need to clean that up. But anyway, if I want to find something I just worked on recently, it could be anywhere within the list. Excel names the files Book1, Book2, etc., so, if I could find the highest number 'book,' I guess that would be the most recent. How can I sort to display that? Or, how could I sort by the last autosave date? I could easily find it that way.

Same 'problem' exists in Word.

I think I have Excel 2010.

Awesome that somebody finally answered, lol, but how do I "run the code" after pasting the path into A1?

It seems a miracle, but I did get it to run. I am not a programmer.

This did not exactly provide what I need. Its output list was in alphabetical order and it did not give a date for each file.

Overall, I was hoping for a way to do it within the Excel Document Recovery pane on the left of the screen.

Thanks for your attempt.

Originally Posted by vichopalacios

Press Alt+F11 to open Visual Basic Editor (VBE).
Right-click on your workbook name in the "Project-VBAProject" pane (at the top left corner of the editor window) and select Insert -> Module from the context menu
Copy the VBA code from my first answer and paste it to the right pane of the VBA editor ("Module1" window).
Press Alt+Q to close the Editor window and switch back to your workbook.
Now you are ready to run the VBA code that you added as described above: press Alt+F8 to open the "Macro" dialog.
Then select the wanted macro from the "Macro Name" list and click the "Run" button.
Good luck

You can't but just open the location in Windows explorer, you can then sort them however you want

That was Magic - Thank you very much Vicho!!
I know this is an old thread, (found on google) but still very much appreciated. I had no idea what I was doing, however followed your instructions and found exactly what I was looking for!!
Thanks again!
Rich