Solved

auto save...    EXcel   and Word

Posted on 2013-02-04
8
294 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…

762 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now