?
Solved

auto save...    EXcel   and Word

Posted on 2013-02-04
8
Medium Priority
?
304 Views
Last Modified: 2013-02-11
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.
0
Comment
Question by:intelogent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
8 Comments
 
LVL 12

Assisted Solution

by:Tony303
Tony303 earned 1000 total points
ID: 38853934
File
Options
Save
0
 
LVL 12

Expert Comment

by:Tony303
ID: 38853942
Here is what it looks like...as attached.
Set your location and time interval.
Doc1.docx
0
 
LVL 12

Accepted Solution

by:
TomRScott earned 1000 total points
ID: 38854031
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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:intelogent
ID: 38870982
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
 
LVL 12

Expert Comment

by:TomRScott
ID: 38872376
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
 

Author Comment

by:intelogent
ID: 38872922
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
 
LVL 12

Expert Comment

by:TomRScott
ID: 38873530
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
 

Author Comment

by:intelogent
ID: 38878032
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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question