PC Review


Reply
Thread Tools Rate Thread

Can I reverse a saved file to the previous file in Excel?

 
 
=?Utf-8?B?aGlnaGxhbmRtb20=?=
Guest
Posts: n/a
 
      27th Aug 2007
I made some changes to a spread sheet that were wrong and then saved the file
and would like to be able to go back to the previous version of this file.
Is that possible?
 
Reply With Quote
 
 
 
 
David Biddulph
Guest
Posts: n/a
 
      27th Aug 2007
It is if you saved a backup. The option for "Always save a backup" is
available under File/ Save As/ Options.
--
David Biddulph

"highlandmom" <(E-Mail Removed)> wrote in message
news:7747D9BA-D02C-4DE3-8137-(E-Mail Removed)...
>I made some changes to a spread sheet that were wrong and then saved the
>file
> and would like to be able to go back to the previous version of this file.
> Is that possible?



 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      27th Aug 2007
Not unless you have another copy, for instance if you have sent or received
the file via email prior to the latest change you did and you can go to your
email and pull that copy. In the 2007 version I believe you can undo if you
haven't closed the file after saving but in earlier versions it is not
possible


--
Regards,

Peo Sjoblom



"highlandmom" <(E-Mail Removed)> wrote in message
news:7747D9BA-D02C-4DE3-8137-(E-Mail Removed)...
>I made some changes to a spread sheet that were wrong and then saved the
>file
> and would like to be able to go back to the previous version of this file.
> Is that possible?



 
Reply With Quote
 
=?Utf-8?B?Y2hhbGxhIHByYWJodQ==?=
Guest
Posts: n/a
 
      28th Aug 2007
Hi,

Caution: The moment you notice that the previous version of the file is
important, do no save the current file again.

Important:

You can get back to your previous saved verison only if you have done the
following;

1. On the Tools menu, click Options,
2. Click the Save tab.
3. Verify that you have selected the "Save AutoRecover info every" list box,
and then if you typed a number value or you have the arrow to the right of
the "Save AutoRecover info every" list. You can increase or decrease the
value by clicking the up or down arrow key.
4. Save the path for the autorecovery in the AutoRecover save location text
path.
5. Under the Workbook option, verify that the Disable AutoRecover checkbox
is cleared.
6. Click OK to save the settings and return to the worksheet.

Otherwise, you will loose the previous backup file.

Note: This is just an assumption. If you have emailed any of the previous
backup file to anyone, then you can request them to send back that copy to
you. This help you modify the cahnges you require in your workbook.

Challa Prabhu



"highlandmom" wrote:

> I made some changes to a spread sheet that were wrong and then saved the file
> and would like to be able to go back to the previous version of this file.
> Is that possible?

 
Reply With Quote
 
David Biddulph
Guest
Posts: n/a
 
      28th Aug 2007
Am I confused?

I thought that the AutoRecover option was to do an automatic save to avoid
losing information that *hasn't* been saved manually (to cope with
situations like power failures). I thought from
http://support.microsoft.com/kb/289273 that the AutoRecover data was cleared
when a manual save is done.

My understanding is that what was needed to cover the OP's situation is
*not* the AutoRecover option but the option for "Always create backup". Did
I misunderstand?
--
David Biddulph

"challa prabhu" <(E-Mail Removed)> wrote in message
news:5A73BF9E-6ABB-4A7B-981B-(E-Mail Removed)...
> Hi,
>
> Caution: The moment you notice that the previous version of the file is
> important, do no save the current file again.
>
> Important:
>
> You can get back to your previous saved verison only if you have done the
> following;
>
> 1. On the Tools menu, click Options,
> 2. Click the Save tab.
> 3. Verify that you have selected the "Save AutoRecover info every" list
> box,
> and then if you typed a number value or you have the arrow to the right of
> the "Save AutoRecover info every" list. You can increase or decrease the
> value by clicking the up or down arrow key.
> 4. Save the path for the autorecovery in the AutoRecover save location
> text
> path.
> 5. Under the Workbook option, verify that the Disable AutoRecover checkbox
> is cleared.
> 6. Click OK to save the settings and return to the worksheet.
>
> Otherwise, you will loose the previous backup file.
>
> Note: This is just an assumption. If you have emailed any of the previous
> backup file to anyone, then you can request them to send back that copy
> to
> you. This help you modify the cahnges you require in your workbook.
>
> Challa Prabhu
>
>
>
> "highlandmom" wrote:
>
>> I made some changes to a spread sheet that were wrong and then saved the
>> file
>> and would like to be able to go back to the previous version of this
>> file.
>> Is that possible?



 
Reply With Quote
 
Peo Sjoblom
Guest
Posts: n/a
 
      28th Aug 2007
No you are correct, autorecovery is not a backup per see, it protects you
against crashes but once you successfully save a workbook autorecovery will
not keep a backup copy of a previously saved file. If you select always
create backup in the save as dialogue box it will save a copy of the
previously saved file so unless the OP worked on the file and saved twice
this would have helped her


--
Regards,

Peo Sjoblom



"David Biddulph" <groups [at] biddulph.org.uk> wrote in message
news:46d3fe4f$(E-Mail Removed)...
> Am I confused?
>
> I thought that the AutoRecover option was to do an automatic save to avoid
> losing information that *hasn't* been saved manually (to cope with
> situations like power failures). I thought from
> http://support.microsoft.com/kb/289273 that the AutoRecover data was
> cleared when a manual save is done.
>
> My understanding is that what was needed to cover the OP's situation is
> *not* the AutoRecover option but the option for "Always create backup".
> Did I misunderstand?
> --
> David Biddulph
>
> "challa prabhu" <(E-Mail Removed)> wrote in message
> news:5A73BF9E-6ABB-4A7B-981B-(E-Mail Removed)...
>> Hi,
>>
>> Caution: The moment you notice that the previous version of the file is
>> important, do no save the current file again.
>>
>> Important:
>>
>> You can get back to your previous saved verison only if you have done the
>> following;
>>
>> 1. On the Tools menu, click Options,
>> 2. Click the Save tab.
>> 3. Verify that you have selected the "Save AutoRecover info every" list
>> box,
>> and then if you typed a number value or you have the arrow to the right
>> of
>> the "Save AutoRecover info every" list. You can increase or decrease the
>> value by clicking the up or down arrow key.
>> 4. Save the path for the autorecovery in the AutoRecover save location
>> text
>> path.
>> 5. Under the Workbook option, verify that the Disable AutoRecover
>> checkbox
>> is cleared.
>> 6. Click OK to save the settings and return to the worksheet.
>>
>> Otherwise, you will loose the previous backup file.
>>
>> Note: This is just an assumption. If you have emailed any of the previous
>> backup file to anyone, then you can request them to send back that copy
>> to
>> you. This help you modify the cahnges you require in your workbook.
>>
>> Challa Prabhu
>>
>>
>>
>> "highlandmom" wrote:
>>
>>> I made some changes to a spread sheet that were wrong and then saved the
>>> file
>>> and would like to be able to go back to the previous version of this
>>> file.
>>> Is that possible?

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saved as WMA file, how to reverse it? =?Utf-8?B?RWQ=?= Windows XP MovieMaker 1 4th Nov 2006 07:31 PM
how to recover a previous version of a saved file in excel 2002 =?Utf-8?B?TEVF?= Microsoft Excel Crashes 1 1st Jun 2006 09:57 PM
Can I access the previous version of a saved file? =?Utf-8?B?SkND?= Microsoft Excel Misc 10 21st Nov 2005 08:24 PM
How can I open previous version of saved file in Excel? =?Utf-8?B?Q2luZHkgVy4=?= Microsoft Excel Misc 1 1st Aug 2005 10:33 PM
how do i open pst file that i saved from previous email? =?Utf-8?B?RG9uSnVhbg==?= Microsoft Outlook Installation 2 27th Apr 2005 02:23 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 02:59 AM.