|gives error that "file does not exist" and has destroyed it|
I'm assuming that you navigated to the correct directory and eye-balled it
to make sure the file was actually gone, not just hiding under a temp name
This is from MS:
"Process to save a file
Excel follows these steps when it saves a file:
Excel creates a randomly named temporary file (for example, Cedd4100 without a file name extension) in the destination folder that you specified in the Save As dialog box. The whole workbook is written to the temporary file.
If changes are being saved to an existing file, Excel deletes the original file.
Excel renames the temporary file. Excel gives the temporary file the file name that you specified (such as Book1.xls) in the Save As dialog box."
See here for some more info:
Not sure if any of this is applicable to Win 10.