Help!

Have saved over excel worksheet - how to revert to old wor..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  move sheet to another workbook dates change  
Author Message
Teacherzzz
External


Since: Oct 01, 2006
Posts: 2



PostPosted: Sun Oct 01, 2006 8:34 pm    Post subject: Have saved over excel worksheet - how to revert to old worksheet?
Archived from groups: microsoft>public>excel>newusers (more info?)

I was working on a new document. I pushed Save As. Somehow I managed to
select my worksheet that I use as a database and saved over it. I then
closed Excel. I didn't realise what I had done until after I had closed the
document and tried to open my worksheet I use as a database. How do I
recover the old version of my worksheet? Please help!!!
Back to top
JLatham
External


Since: Sep 19, 2006
Posts: 1515



PostPosted: Sun Oct 01, 2006 9:21 pm    Post subject: RE: Have saved over excel worksheet - how to revert to old worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

This is one of those times that it is my sad duty to be the bearer of
probably even sadder tidings: Having saved over a file, that original file
is gone.

Hopefully you routinely make backups of critical files and can recover from
that backup copy?

"Teacherzzz" wrote:

> I was working on a new document. I pushed Save As. Somehow I managed to
> select my worksheet that I use as a database and saved over it. I then
> closed Excel. I didn't realise what I had done until after I had closed the
> document and tried to open my worksheet I use as a database. How do I
> recover the old version of my worksheet? Please help!!!
Back to top
JMB
External


Since: Jun 08, 2005
Posts: 1029



PostPosted: Mon Oct 02, 2006 2:17 am    Post subject: RE: Have saved over excel worksheet - how to revert to old worksheet? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I'm guessing you're not on a network or you'd likely have already checked
w/your IT people.

If it's really important, there is software available that will attempt to
retrieve the data - you'll need to check around as I've never used any (using
a different computer as the more you use it, the less chance of recovery).

Other links from previous posts
http://www.aumha.org/a/recover.php
http://www.active-undelete.com
http://www.FinalRecover.com

Did you email it to anyone or recently delete an older version (which may
still be in the recycle bin)? I've read Norton Utilities (if you have it
installed) may be able to recover a previous version of a file.




"Teacherzzz" wrote:

> I was working on a new document. I pushed Save As. Somehow I managed to
> select my worksheet that I use as a database and saved over it. I then
> closed Excel. I didn't realise what I had done until after I had closed the
> document and tried to open my worksheet I use as a database. How do I
> recover the old version of my worksheet? Please help!!!
Back to top
Teacherzzz
External


Since: Oct 01, 2006
Posts: 2



PostPosted: Mon Oct 02, 2006 4:56 am    Post subject: RE: Have saved over excel worksheet - how to revert to old workshe [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I was seriously hoping that I would get a different answer. Thank you very
much for your time. It unfortuanetly confirms what two hours of trying
everything I could possibly think of has also told me. Now I am wondering
why XP 2000 home edition doesn't come with a standard back up facility
installed. I just assumed.... But then we all know what assumed makes of u
and me (In this case just me!)

Again thank you for your time

"JLatham" wrote:

> This is one of those times that it is my sad duty to be the bearer of
> probably even sadder tidings: Having saved over a file, that original file
> is gone.
>
> Hopefully you routinely make backups of critical files and can recover from
> that backup copy?
>
> "Teacherzzz" wrote:
>
> > I was working on a new document. I pushed Save As. Somehow I managed to
> > select my worksheet that I use as a database and saved over it. I then
> > closed Excel. I didn't realise what I had done until after I had closed the
> > document and tried to open my worksheet I use as a database. How do I
> > recover the old version of my worksheet? Please help!!!
Back to top
JLatham
External


Since: Sep 19, 2006
Posts: 1515



PostPosted: Mon Oct 02, 2006 8:49 am    Post subject: RE: Have saved over excel worksheet - how to revert to old workshe [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Look in [Start] [Programs] [Accessories] [System Tools] there is a Backup
function buried in there.

Since there was a time when backup wasn't such a friendly beast to play
with, I picked up on a program called SecondCopy from www.centered.com some
years ago and have found it easy to use and extremely reliable and versatile.

"Teacherzzz" wrote:

>
> I was seriously hoping that I would get a different answer. Thank you very
> much for your time. It unfortuanetly confirms what two hours of trying
> everything I could possibly think of has also told me. Now I am wondering
> why XP 2000 home edition doesn't come with a standard back up facility
> installed. I just assumed.... But then we all know what assumed makes of u
> and me (In this case just me!)
>
> Again thank you for your time
>
> "JLatham" wrote:
>
> > This is one of those times that it is my sad duty to be the bearer of
> > probably even sadder tidings: Having saved over a file, that original file
> > is gone.
> >
> > Hopefully you routinely make backups of critical files and can recover from
> > that backup copy?
> >
> > "Teacherzzz" wrote:
> >
> > > I was working on a new document. I pushed Save As. Somehow I managed to
> > > select my worksheet that I use as a database and saved over it. I then
> > > closed Excel. I didn't realise what I had done until after I had closed the
> > > document and tried to open my worksheet I use as a database. How do I
> > > recover the old version of my worksheet? Please help!!!
Back to top
Gord Dibben
External


Since: Feb 23, 2004
Posts: 9431



PostPosted: Mon Oct 02, 2006 2:30 pm    Post subject: Re: Have saved over excel worksheet - how to revert to old workshe [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

XP Home Edition does not install the backup by default.

Backup is installed automatically on XP Professional, but not on
XP Home. If you have the complete XP Home CD, find backup on the CD, in
\ValueAdd\MSFT\NTBACKUP and install it yourself by doubleclicking the file
ntbackup.msi.

If you don't have an XP CD, you can download ntbackup.msi at
http://www.onecomputerguy.com/software/ntbackup.msi Also see
http://support.microsoft.com/?kbid=302894

As far as creating backups in Excel read the following.

AUTOSAVE.XLA was last shipped with Excel 2000 and newer versions do not include
it.

It cannot be found on any MS site but..............

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

I have used the 97 version on Excel 2002 and 2003 and seems to operate well.

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe
which also doen't alert before saving.

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)


Gord Dibben MS Excel MVP



On Mon, 2 Oct 2006 04:49:01 -0700, JLatham <HelpFrom @
Jlathamsite.com.(removethis)> wrote:

>Look in [Start] [Programs] [Accessories] [System Tools] there is a Backup
>function buried in there.
>
>Since there was a time when backup wasn't such a friendly beast to play
>with, I picked up on a program called SecondCopy from www.centered.com some
>years ago and have found it easy to use and extremely reliable and versatile.
>
>"Teacherzzz" wrote:
>
>>
>> I was seriously hoping that I would get a different answer. Thank you very
>> much for your time. It unfortuanetly confirms what two hours of trying
>> everything I could possibly think of has also told me. Now I am wondering
>> why XP 2000 home edition doesn't come with a standard back up facility
>> installed. I just assumed.... But then we all know what assumed makes of u
>> and me (In this case just me!)
>>
>> Again thank you for your time
>>
>> "JLatham" wrote:
>>
>> > This is one of those times that it is my sad duty to be the bearer of
>> > probably even sadder tidings: Having saved over a file, that original file
>> > is gone.
>> >
>> > Hopefully you routinely make backups of critical files and can recover from
>> > that backup copy?
>> >
>> > "Teacherzzz" wrote:
>> >
>> > > I was working on a new document. I pushed Save As. Somehow I managed to
>> > > select my worksheet that I use as a database and saved over it. I then
>> > > closed Excel. I didn't realise what I had done until after I had closed the
>> > > document and tried to open my worksheet I use as a database. How do I
>> > > recover the old version of my worksheet? Please help!!!

Gord Dibben MS Excel MVP
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum