Excel workbook disappeared without saving - how to recover

cpu97

Board Regular
Joined
Jan 8, 2010
Messages
64
Hi,

Today I started filling in data in a blank workbook (Windows 10, Excel 2019). The excel window was not full screen as I was going back and forth between excel and another application. I highlighted two rows and tried to click on unfreeze panes, and all of a sudden the spreadsheet is gone. It was as if I had clicked on the other application to put it into focus and the spreadsheet was hidden behind it, but that's not the case. All of the other spreadsheets I have open are still open, but this new one mysteriously disappeared. Usually I get a warning about closing without saving, but not this time. Foolish of me not to save earlier, I know, but is there any way to recover this recent file?

Thanks for considering.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
14,565
Office Version
  1. 365
Platform
  1. Windows
Go to the Excel File menu, then Open.
At the bottom there should be a button to 'Recover unsaved workbooks'. If you can't find it there then it's time to start again :eek:
 
Solution

cpu97

Board Regular
Joined
Jan 8, 2010
Messages
64
Thank you - unfortunately the list includes only workbooks I was prompted to save prior to closing. Back to the drawing board! Very odd.
 

Forum statistics

Threads
1,148,257
Messages
5,745,712
Members
423,969
Latest member
seanguerrero

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top