oh boy. this is quite unbelievable. here is how I found my auto recovered Excel file (not what I expected at all):
- I kept searching for a term that I knew was in the document, the term was "spruce".
- My finder brought up results from other files I had saved at that time using term "spruce" (some screenshots I had taken and a pdf.
- Those results gave me the date of "11/24/24"
- I changed all of my folders to show a "date created" and sorted by date. I looked in desktop, documents, downloads for the 11/24/24 date.
- I found a different file I had been working on in Excel on 11/24/24 in the my documents.
- I clicked on that file and when it opened, at the top in a little call-out ribbon/dialog box in yellow at the top said something like "Auto Recovered - you have an unsaved version of your document do you want to open it" with a button for "yes" or "no". I clicked yes.
- all of a sudden 3 "auto recovered" excel files I had been apparently last working with on 11/24/124 came up with titles of "book 1 (version 1).xlsb - auto recovered" (see screenshot below)
8. when I click on the little down carrot to the right of auto recovered, it brings up this box:
9. I went to a random, different Excel file and opened it to see if the same little call-out ribbon/dialog box in yellow at the top said something like "Auto Recovered - you have an unsaved version of your document do you want to open it" would open......it DID NOT. the little dialogue box was not there.
10. therefore, if I had NOT found the date and went looking for the date in my mac's folders/files (i.e. downloads, documents, etc), I wouldn't have found the other work I had done on that date. For some reason, the Excel file that was stored in my documents with same date must have had two versions - one where I had saved it, and one where I had not (and it auto recovered). Clicking on the saved version brought up the autorecovery dialogue box. 11. obviously I have autorecovery set to "on" in my excel and this is why I couldn't locate the auto recovered files using library/containers etc the way I do with Word?
thank you anyone for any guidance/feedback on all of this.