Can anyone please direct me how to find the automatic log in Excel that saves
previous work that apparently I didn't save--hope to not have lost some
tedious full day work which I cannot find through Search function.
--
Thank you,
Esther

Excel doesn't have a secret log file--or even a known log file.

If you didn't save the changes, then you're out of luck.

But for the next time...

Just some background:

xl2k and below came with an optional addin called AutoSave.xla. It could be set
to save every x minutes (user selectable). And it just saves the file at those
intervals.

xl2002+ comes with something called autorecovery. It's also optional, but if
the user turns it on, it saves a copy of that workbook in a special location
(also user selectable). If windows or excel crashes, then the next time excel
opens, it notices that there's a file in that location. Excel prompts the user
to see if he/she wants to recover that file that was saved when excel/windows
crashed.

This autorecovery feature isn't used for the same purpose as AutoSave.

You may be interested in an addin that Jan Karel Pieterse (works in any version)
called AutoSafe (note spelling).

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.

http://www.jkp-ads.com/Download.htm
(look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)

If you really want autosave...

Gord Dibben posted this:

Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
If you have a previous copy, move it to your Office\Library.
To download the 97 version see here........
http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

==
I've never tried it in xl2007. If you're using xl2007, you may want to do some
testing before you rely on it.



Esther not the queen wrote:
>
> Can anyone please direct me how to find the automatic log in Excel that saves
> previous work that apparently I didn't save--hope to not have lost some
> tedious full day work which I cannot find through Search function.
> --
> Thank you,
> Esther

--

Dave Peterson

You're a real wealth of resources Dave, really thanks a lot.

since I work on 2003 version all these auto saves options are relevant--alas
my work this time, but these will help for possible next such projects...
--
Thank you,
Esther


"Dave Peterson" wrote:

> Excel doesn't have a secret log file--or even a known log file.
>
> If you didn't save the changes, then you're out of luck.
>
> But for the next time...
>
> Just some background:
>
> xl2k and below came with an optional addin called AutoSave.xla. It could be set
> to save every x minutes (user selectable). And it just saves the file at those
> intervals.
>
> xl2002+ comes with something called autorecovery. It's also optional, but if
> the user turns it on, it saves a copy of that workbook in a special location
> (also user selectable). If windows or excel crashes, then the next time excel
> opens, it notices that there's a file in that location. Excel prompts the user
> to see if he/she wants to recover that file that was saved when excel/windows
> crashed.
>
> This autorecovery feature isn't used for the same purpose as AutoSave.
>
> You may be interested in an addin that Jan Karel Pieterse (works in any version)
> called AutoSafe (note spelling).
>
> 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.
>
> http://www.jkp-ads.com/Download.htm
> (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
>
> If you really want autosave...
>
> Gord Dibben posted this:
>
> Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
> If you have a previous copy, move it to your Office\Library.
> To download the 97 version see here........
> http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm
>
> ==
> I've never tried it in xl2007. If you're using xl2007, you may want to do some
> testing before you rely on it.
>
>
>
> Esther not the queen wrote:
> >
> > Can anyone please direct me how to find the automatic log in Excel that saves
> > previous work that apparently I didn't save--hope to not have lost some
> > tedious full day work which I cannot find through Search function.
> > --
> > Thank you,
> > Esther
>
> --
>
> Dave Peterson
>

There's another option that's not related to autosave, but may come in handy.

File|saveas|tools|General Options|check the "always create backup" box.

This is a workbook by workbook setting. And excel will create a .xlk file when
you save (I think the first save after you open the file, but you'll want to
check the details).

Esther not the queen wrote:
>
> You're a real wealth of resources Dave, really thanks a lot.
>
> since I work on 2003 version all these auto saves options are relevant--alas
> my work this time, but these will help for possible next such projects...
> --
> Thank you,
> Esther
>
> "Dave Peterson" wrote:
>
> > Excel doesn't have a secret log file--or even a known log file.
> >
> > If you didn't save the changes, then you're out of luck.
> >
> > But for the next time...
> >
> > Just some background:
> >
> > xl2k and below came with an optional addin called AutoSave.xla. It could be set
> > to save every x minutes (user selectable). And it just saves the file at those
> > intervals.
> >
> > xl2002+ comes with something called autorecovery. It's also optional, but if
> > the user turns it on, it saves a copy of that workbook in a special location
> > (also user selectable). If windows or excel crashes, then the next time excel
> > opens, it notices that there's a file in that location. Excel prompts the user
> > to see if he/she wants to recover that file that was saved when excel/windows
> > crashed.
> >
> > This autorecovery feature isn't used for the same purpose as AutoSave.
> >
> > You may be interested in an addin that Jan Karel Pieterse (works in any version)
> > called AutoSafe (note spelling).
> >
> > 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.
> >
> > http://www.jkp-ads.com/Download.htm
> > (look for AutoSafe.zip, not autosafeVBE.zip, for your purposes.)
> >
> > If you really want autosave...
> >
> > Gord Dibben posted this:
> >
> > Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003.
> > If you have a previous copy, move it to your Office\Library.
> > To download the 97 version see here........
> > http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm
> >
> > ==
> > I've never tried it in xl2007. If you're using xl2007, you may want to do some
> > testing before you rely on it.
> >
> >
> >
> > Esther not the queen wrote:
> > >
> > > Can anyone please direct me how to find the automatic log in Excel that saves
> > > previous work that apparently I didn't save--hope to not have lost some
> > > tedious full day work which I cannot find through Search function.
> > > --
> > > Thank you,
> > > Esther
> >
> > --
> >
> > Dave Peterson
> >

--

Dave Peterson