auto save... EXcel and Word

is thee a way to configure MS excel and Word to automatically save a copy.  so many times i am asked to see if i can recover a disaterous loss...which was not saved upon closing.
intelogentAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
TomRScottConnect With a Mentor Commented:
Word is easy:
Before Word 2007
1  Tools / Options
2  Save Tab
3  Check the Always create backup copy check box
Word 2007
1  Office Button / Word Options
2  Click the Advanced button
3  Scroll down to the Save section
4  Check the Always create backup copy check box
Word 2010
1  File tab
2  Click the Options menu item or button
3  Click the Advanced button
4  Scroll down to the Save section
5  Check the Always create backup copy check box
Excel is a little harder and only per workbook:
After Excel 97
1  Get to the Save As window (differs based on version)
2  Find the Tools drop-down button and click the down arrow
3  Select the General Options... menu item
4  Check the Always create backup option
I have NOT tried it yet, but I suspect you could also set the default template(s) for Excel using the Save As procedure above and this would work for all following new workbooks. Using templates would not work for existing workbooks nor workbooks created elsewhere. For existing workbooks, the procedure above would need to be performed for each workbook.

I'm not covering the creation of the default templates for Excel here, but it is easy to look up.

BTW, it helps if you include the version number as there are differences, as demonstrated above.
0
 
Tony303Connect With a Mentor Commented:
File
Options
Save
0
 
Tony303Commented:
Here is what it looks like...as attached.
Set your location and time interval.
Doc1.docx
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
intelogentAuthor Commented:
thank you for responding....

 office 2010


i tried with word... unsucessful at least if i undeerstand what this configurations accomplish.

auto save  - 5 min    and a ck is on the " keep the last autosave if i close without saving.

i opened word... wrote something.. then     held it open for quite some time.   then closed with out saving... no saved back up was there for me.


is that not what this is suppose to accomplish.?
0
 
TomRScottCommented:
The autosave is for crashes.  When you exit the program with or without a save it "cleans up" temporary files and autosaves.

If word crashes, the autosave is left behind.  When an office product is started the next time, and it finds an autosave file, it prompts you for how you wish to handle it.

If you perform the steps earlier in the thread for a backup copy, then the backup copy is made when you perform a save.

 - Tom
0
 
intelogentAuthor Commented:
ah...

so then is there a program which will automatically save the last thing i have worked on, and thereby prevent my inadvertant " i forgot to save disaster" ?
0
 
TomRScottCommented:
Not exactly.

First off, the user can't really "forget" to save.  If changes have been made to a "document" (any Office document regardless of type), the Office program will prompt the user to choose to save or not.

If  the user chooses not to save then no backup is made and the autosave file is removed during the clean-up as the Office product exits.

 - Tom
0
 
intelogentAuthor Commented:
ok ... thanks  for the help... i wish they had an option to autosave everything untill te next document , and then that would write over the prior......

woul dmake many happier.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.