close

I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
an excel doc without saving changes thinking I was closing the earlier
version of the doc. Needless to say I was terribly disapointed to find I
closed the wrong version of the doc. Is there any way to retrieve the doc
with the changes made to it.

No. Sorry.

BrianH

quot;Jimquot; wrote:

gt; I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
gt; an excel doc without saving changes thinking I was closing the earlier
gt; version of the doc. Needless to say I was terribly disapointed to find I
gt; closed the wrong version of the doc. Is there any way to retrieve the doc
gt; with the changes made to it.

Nope.

If you never saved it, all the changes are gone.

Jim wrote:
gt;
gt; I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
gt; an excel doc without saving changes thinking I was closing the earlier
gt; version of the doc. Needless to say I was terribly disapointed to find I
gt; closed the wrong version of the doc. Is there any way to retrieve the doc
gt; with the changes made to it.

--

Dave Peterson

For clarification, what if it was an existing file? I modified it, but never
saved about two hours worth of work. My autorecovery interval is set to
every 10 minutes. Why are there no recovery files in the folder for this
interval of time?

quot;Dave Petersonquot; wrote:

gt; Nope.
gt;
gt; If you never saved it, all the changes are gone.
gt;
gt; Jim wrote:
gt; gt;
gt; gt; I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
gt; gt; an excel doc without saving changes thinking I was closing the earlier
gt; gt; version of the doc. Needless to say I was terribly disapointed to find I
gt; gt; closed the wrong version of the doc. Is there any way to retrieve the doc
gt; gt; with the changes made to it.
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Saved from a previous post:

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.

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........
www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

JC Stokoe wrote:
gt;
gt; For clarification, what if it was an existing file? I modified it, but never
gt; saved about two hours worth of work. My autorecovery interval is set to
gt; every 10 minutes. Why are there no recovery files in the folder for this
gt; interval of time?
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; Nope.
gt; gt;
gt; gt; If you never saved it, all the changes are gone.
gt; gt;
gt; gt; Jim wrote:
gt; gt; gt;
gt; gt; gt; I am using WinXP home edition and Excel in Office 2000. I inadvertly closed
gt; gt; gt; an excel doc without saving changes thinking I was closing the earlier
gt; gt; gt; version of the doc. Needless to say I was terribly disapointed to find I
gt; gt; gt; closed the wrong version of the doc. Is there any way to retrieve the doc
gt; gt; gt; with the changes made to it.
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()