A word of warning though: this isn’t foolproof, and it doesn’t always work. Saving regularly and backup up these saves to the cloud is always a better bet.

  1. Open a blank Microsoft Excel document and click the File tab.
  2. Click the Options link at the bottom.
  3. Choose the Save option from the left. 4.Once you find the section with a path showing where your autosaved documents go, select and copy it. In my case, it’s here: C:\Users\Bryan\AppData\Roaming\Microsoft\Excel\
  4. Open File Explorer and paste in the copied file path. Hit enter.
  5. Here, we’ll see the last save of the document I was working on, which starts with the name “MYDOC.” Click it to open the file.
  6. Right click the Microsoft Excel Binary file, and select Open with.
  7. Choose Excel, and click Ok. Check out our list of Excel tips below, including tutorials on How to Freeze Rows in Excel, How to Lock Cells in Excel, How to Use VLOOKUP in Excel to boost your productivity in a big way.

Microsoft Excel Tips

Previous TipNext Tip

Use VLOOKUP in ExcelBack Up Files Automatically in ExcelRemove Duplicate Data in ExcelCreate a Waterfall Chart in ExcelLock Cells in ExcelFreeze Rows and Columns in ExcelBuild a Forecast Chart in ExcelCreate a Funnel Chart in ExcelMake a Treemap in ExcelConvert Excel Sheets to Google SheetsOpen Google Sheets in ExcelCombine Data from Different CellsMerge Cells to Span Multiple ColumnsUse AutoFill for Repetitive DataCopy and Paste Repetitive Data the Easy WayUse Text to ColumnsDraw Diagonal Line in a CellCreate a New Shortcut MenuTranspose Columns Using Paste Special