Re: Duh. Closed a file without saving.

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks, Bob.

I was afraid that that would be the answer.

Here, however, was my reasoning. I had had that "untitled.xlm" file
open and continually changing for the best part of four hours.
Hypothetically, if Excel had "unexpectedly quit" on me (as Excel is
wont to do from time to time on a Macintosh) at any time BEFORE I
closed it, then it would very probably have been optioned for recovery
the next time I booted Excel. Is this not usually the case?

To do this, Excel must surely have been saving regular copies of such
things as my macros and the contents of the open spreadsheets to disk -
even before I decided to close the workbook.

It seems logical then that, had I an understanding of WHERE such
"temporary" files were written, I ought to be able to retrieve them. I
also appreciate that, in practice, there may be all sorts of barriers
to my reading the files once I found them. It's also feasible that,
once the file has been closed, Microsoft marks the disk sectors that
contain the temp files as disposable (and then that OSX - which makes a
point of defragging as it goes - writes over the same sectors). But,
for an untitled file to be recoverable, temporary files must, at some
time, exist. Nicht War?

.

Quantcast