Excel worksheets missing

[BabuS1690]

I have Office 365 installed on my Mac that uses macOS Catalina Version 10.15.4

Today I notice that all the Excel Worksheets that I had saved are missing. I never used to save them to another folder but had them as temporary files in the excel app. I used to go to 'Recent' and open the worksheet that I needed.

Please suggest a way I can recover my worksheets from Excel since the files are not saved elsewhere.

[#2]

@BabuS1690 I am a bit confused by your comment "I never used to save them to another folder but had them as temporary files in the excel app."   They must have been saved to your Mac or to your iCloud.

Have you searched in Finder to see if you can find them if Excel isn't now showing them as recent files?

Do you have a Timemachine configured?