Solved

auto save...    EXcel   and Word

Posted on 2013-02-04
8
299 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

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

 

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 Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel if formula 2 19
Excel Calculation 4 46
need formula to remove the first word in an excel cell 4 17
VBA MsgBox command is dumping object variables? 8 30
Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
This article will show you how to use shortcut menus in the Access run-time environment.
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

808 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