Question: where are temporary excel files stored on mac?
Answer: Go to "Applications" > "Utilities" > "Terminal".
Type open $TMPDIR and press "Return" to open the Temporary files folder. Select the folder named "TemporaryItems".
Find the unsaved Excel file under "TemporaryItems" and restore.