Excel File Vanished or Disappeared

Question

Hi. Today I was working on an excel sheet in Office 365 on Windows 10. I hit Ctrl Save as I regularly do. However this time the program stopped.

When I re-opened the program I and tried to open my recent file it told me that it was either deleted or moved. I went to the original file location. It was gone. I checked the recycle bin. It was not there. I did a search for the file by name. It does not come up. I searched all .xls files. It doesn't show up anywhere. I don't have onecloud set up. My backup which is automated by windows onto an external drive I now discover has not been backing up...

Does anyone know if it is possible to retrieve this file. It must be somewhere?

Thanks very much

Answer 1

In Excel, try opening it by changing the file filter when opening to show all files. It should show up then.

Answer 2

There may be a copy saved in a temp folder. Please see here for more information:

https://social.technet.microsoft.com/Forums/off...

Answer 3

Thanks very much. I've found what appears to be the temp file (I hope so anyway), however, I can't do anything with it yet. I can't find it through excel and I found nothing in C:\Users\name\AppData\Roaming\Microsoft\Excel\ 

Any suggestions on using the TMP file?

Thanks again.

Answer 4

Wow! It has been found, opened, renamed and saved!

Thanks so much. It has 9 years of records and because the backups had failed there was no update since 2016.

Answer 5

You're welcome. Glad it worked out for you.