Hi Ayush, could you plz let me know were can find this option in Excel 2007.
Thanks, Sai On Thu, Sep 17, 2009 at 6:51 PM, Aindril De <[email protected]> wrote: > Hats Off Ayush... > Excellent Tip... > > > Regards, > Andy > > On Thu, Sep 17, 2009 at 7:31 PM, Ayush Jain <[email protected]>wrote: > >> ** >> Do you have important Excel files that would create nothing short of chaos >> and disaster for you if you were to lose those files? >> Now I'm sure that you regularly make copies of these files just in case - >> but wouldn't it be nice if Excel could help us out a bit on this score? >> Yeah - I thought so too so I did some research… >> I found in the options of Excel's Save As window a little backup for our >> very important files. >> To take a look you'll need to go to the *Save As *window, *Tools* menu, >> *General >> Options* choice. >> [image: Click Here For More Mails - gurlzgroup >> -]<http://www.gurlzgroup.blogspot.com/> >> At the top of the Save Options window that opens you should see a checkbox >> for something labeled as "*Always create backup*". >> [image: Click Here For More Mails - gurlzgroup >> -]<http://www.gurlzgroup.blogspot.com/> >> Should you choose to* check this option *and *click OK *what will happen >> is obvious. >> Every time you save, after the initial Save As, Excel will create a backup >> file too - automatically. >> Yes - it's that easy to get Excel to lend a helping hand. >> Now - I did do some experimenting with this and found that the backup >> always seemed to be one version of the file behind. In other words - the >> latest changes were saved in the actual file and the backup file was saved >> without the newest changes. This could be useful in the "Oh man, I really >> messed up this file" arena. >> Also, to actually see the backup when trying to open it you'll need to >> change the type of file you're looking for in the Open window. You could try >> All Files or you could scroll way to the bottom of the list where you'll >> find Backup Files listed. Either way - the backup is not listed among your >> usual files. It's called "Backup of xxxxx". >> Just one more strategy to employ in the never-ending battle against lost >> data. >> >> __,_._,___ >> >> >> ------------------------------ >> Love Cricket? Check out live scores, photos, video highlights and more. Click >> here <http://in.rd.yahoo.com/tagline_cricket_2/*http://cricket.yahoo.com> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to [email protected] If you find any spam message in the group, please send an email to: Ayush Jain @ [email protected] or Ashish Jain @ [email protected] <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
