I work in the the latest version of Excel 365 (16.21.1), so that cannot be the problem. The tip to enter open $TMPDIR in Terminal (look in ) did not work either. But after reading hundreds of comments on dozens of forums I saw that I was not alone in not finding the path at all.
Perhaps that is the case for some versions of Excel for Mac. Perhaps for some people the files are actually there. Even Microsoft believes the /Data/Library/Preferences/AutoRecovery path exists and contains your valuable recovery files. Many sites make you believe that Excel works the same way. You can navigate with Finder to that path and find your recovery files there. Users//Library/Containers//Data/Library/Preferences/AutoRecovery Users//Library/Containers//Data/Library/Preferences/AutoRecovery and The location of the recovery files of Word and Powerpoint is well known: Or are you working on files and leave them open for several days and want to make copies each hour or so, just in case, of the recovery files, e.g.
Did you encounter a crash of Word, Powerpoint or Excel? And you want to know where to find the autorecovery files?