I can't find the autosave file in the path provided, help?

[L. Tucker]

I checked my tools/options/save and it says that my spreadsheet should save
every 10 minutes to the path provided in the field box. I tried to follow
that path and there is no file there. I also check to make sure that all
hidden files are being shown and it still isn't there. Does anyone know where
the file goes if the path described for the autosave doesn't show a file?

 

[JE McGimpsey]

You don't say what version of XL you're using, but if it's XL02 (IIRC)
or later, you don't have AutoSave, you have AutoRecover.

With AutoRecover, changes are saved to temporary files while you're
working on the file, and the temporary files are deleted when you quit
XL normally.

 

[Gord Dibben]

Expanding on JE's answer.

Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals. Good or bad feature depending on
how you look at it.

Versions since 2000 use Auto Recovery which only creates a timed but
temporary backup file which is deleted when the workbook is saved or closed
normally.

Auto Recovery is a safety valve in the event of an Excel crash while a
workbook is open.

Jan Karel Pieterse has an addin called AutoSafe
which doen't alert before saving.

http://www.jkp-ads.com/download.asp

(look for AutoSafe.zip)

It doesn't overwrite the existing workbook when it saves. It saves to a
user selectable folder. And when it's done, it either deletes these backups
(or puts them in the recycle bin). And the user can always restore the
backups from the recycle bin.

If you still have access to the AutoSave add-in from Excel 2000 it may work
with 2007................it did work with 2002 and 2003

I can send you the Autosave.xla from XL97 which apparently works under 2007

I know it works for 2002 and 2003


Gord Dibben MS Excel MVP

On Mon, 2 Feb 2009 14:25:01 -0800, L. Tucker <L.