Solved

auto save...    EXcel   and Word

Posted on 2013-02-04
8
300 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
  • 3
  • 3
  • 2
8 Comments
 
LVL 12

Assisted Solution

by:Tony303
Tony303 earned 250 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 250 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

680 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