Document Recovery window shows 2 original versions ???

[JenniferMurphy]

Once more Excel suddenly closed all open workbooks without any error message or options to save them. When I reopened it, the Document Recovery window listed 2 versions of the open books. But for one of them, it listed 3 with 2 of them tagged as "[Original]". The ones tagged as (A) both say Original and both have the same "Original" icon (circled). But the dates are different. What is going on?

 

[JenniferMurphy]

. . . and when I hover over one of the AutoRecovered files, I get a drop down. I tried all but Delete. Nothing happens.

 

[JenniferMurphy]

I tried 2 Explorer searches, one from My Documents and one from This PC, to see if I somehow did create 2 copies of that book.

The one from My Documents finished quickly. It only found 1 copy (plus a ~copy). But when I click on the name ion the search window, it lists 3:

What the heck is the one with the clock (?) icon?

The one from This MC is still running. It's been about 15 minutes. It also only found 1.

 

[NdNoviceHlp]

Hi Jennifer. A while back I did some learning about the document recovery "feature"....

How to detect / bypass the Workbook Recovery window and process

I'm working with a Word/VBA system, and as it goes, it opens an XLSX to get some information from it. One of many users reported that nothing came from the XLSX, so I manually opened Excel to open the file which the code should have opened, just to prove it wasn't a permissions / access issue...

www.mrexcel.com

The link probably won't help you specifically but it does offer some insights into XL's document recovery. I'm guessing that the reason that you have 2 versions of the same recovered wb is that it has crashed before and the registry key remains in reference to the previously crashed version. Do U have all those wb's open at once or is the recovery window showing all of the previous keys to previously crashed wbs? U could clear all of those previous reference keys as outlined at the link either manually with the registry editor or via the code posted (not sure if office 365 is the same as my 2016 version) Anyways, I would suggest turning off your document recovery "feature" as it has been my experience that this "feature" will cause mysterious crashes.... again not sure if this is the case for office 365? Have you checked the task manager to see if XL has actually shut off re. nothing happens when you click the icon list .... maybe the application needs to be terminated and rebooted before further use. Not sure what the clock(?) icon is? Hope that maybe some of this will be helpful. Dave

 

[RoryA]

What the heck is the one with the clock (?) icon?

That's the search history (it filters to whatever matches the current search). If you hover over it, there should be an X to the right that you can use to delete it from the device history.