Document Recovery (AutoRecover) is not working for Excel 2016.
Windows 8.1 64 bit
Microsoft Excel 2016 MSO (16.0.8528.2126) 64 bit
No fix even after a full Online repair of Office 2016 and, of course, all possible Office Updates.
After working for hours on several Excel documents (which had previously been saved with a file name etc.), the power went out in our building. When the power was restored and Excel reopened, I was presented with the expected list of Recovered Documents on the left side. HOWEVER, every single one of these were simply "the Original version" or "the version last saved by user" (something like that).
Meaning they did not contain ANY new data that had been entered since the last time I had saved them/reopened them despite the AutoRecover being set to 1 minute.
1) Document Recovery seems to be working for Word and PP.
2) The settings in Options>Save are all the same for all Office products: currently set to AutoRecover every 1 minute.
3) The ...AppData>Roaming>Microsoft>Excel folder contains no backup file/folder for new or reopened Excel Documents. Thank goodness, the AutoRecover does seem to be updating the equivalent folder for Word ("AutoRecovery save of DocumentX.asd" files get updated) and PowerPoint (the "pptXXX.tmp" file also updated).
Edit: This is obviously some MSOffice Bug. Of the multiple 'test' spreadsheets I've been playing around with to study this, exactly 1 of them seems to actually back up. But absolutely no other ones and none of my previously created sheets ever backup to AutoRecover.