ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Autorecovery (https://www.excelbanter.com/excel-worksheet-functions/45952-autorecovery.html)

Felix

Autorecovery
 
I cannot find the auto-recovered files! Why are they so difficult to find?
The file path given where they should be stored does not exist...
The "Search" function doesn't find them either.
Do they have a seperate extension or .xls?

Thank you
--
Felix

Dave Peterson

If excel closes down normally, then the the auto-recovered files are deleted (no
need to keep them).

And if excel/windows crashes, then the next time excel opens, it'll find
that/those files and give you a prompt asking you if you want to recover
that/those files.

There shouldn't be a reason to actually use those files.

But that folder is user selectable.
Open excel
tools|options|Save tab|autorecover save location box
mine (xl2003/winXP home) is:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\

If I start up excel and wait for that first autorecovery interval (mine's 10
minutes), I see funny named files like:

~ar3366.xar

(.xar is that extension you're looking for).

=======
And all this applies to Autorecovery (xl2002+), not autosave, right?

Felix wrote:

I cannot find the auto-recovered files! Why are they so difficult to find?
The file path given where they should be stored does not exist...
The "Search" function doesn't find them either.
Do they have a seperate extension or .xls?

Thank you
--
Felix


--

Dave Peterson


All times are GMT +1. The time now is 07:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com