OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Automatic Copy/Paste for Microsoft PowerPoint®

Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.


Other Contents
Design Chart Templates for Microsoft® Excel®
Quickly and easily generate your own Org Charts in Excel
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
PC Tip Microsoft® Office® General OfficeHelp Free

AutoSave Documents in Microsoft® Office - Version 1.00

Tested on Microsoft® Office® General Versions: 2000 (9.0), XP (10.0), 2003 (11.0) - should work on any version from Office 97


 

Have you ever lost the work of a full afternoon? Just finishing your afternoon long document and the electric power fails. You remember to save regularly, didn't you? Oops.

Learn how to make office automatically save your work every N minutes (you choose how many) in easy tip. Never loose your work again. Works with Word, Excel and PowerPoint.


Most Microsoft (R) Office application can automatically save recovery information that can be used to recover the file you were working when it failed. Regardless of the cause of the failure (power outage, computer freeze (commonly referred as "application crash") or any other) it will be possible to recover the document from the point of the last automatic save.

In this PC Tip, we will consider and illustrate how to do it for Word, Excel and PowerPoint. Other Office applications may also have this facility. Search for it on the application Help.

Recovery Information vs File Saves

Autosaving is not similar to pressing the save button every X minutes. It won't save your file on your filename at the given interval. Instead, it will save Recovery Information on a specific file each time the interval limit is reached.

How do you recover a document after a failure? Just open again the failed application and it should prompt you with the information that there is a recovery file to be used. You have to accept or deny opening it. If you accept, the file you were working will open, and you should save it to a regular file immediatly.

Be careful: Autorecovery will only work the first time you open the failed application. If you don't recover and save the file data, it will be lost. Always open your failed application first thing after you reopen the PC after a failure and save the data to a regular office file.

In case the recovery file doesn't appear when you reopen the failed application, you can open it as a regular file. The recovery file name is, according to Word 2000 Help file: "AutoRecovery save of file name.asd". The default location is a system folder:  "Windows\Profiles\username\Application Data\Microsoft\Word" folder where username is your login name on the PC. This folder is usually hidden, and it's not easy reaching it. Doing it is outside the scope of this PC TIP. Please refer to the Office Help file for more information (search for "Recovery Info").

Choosing the Right Time Interval

You will be requested to enter the time interval between recovery info saves, in minutes. By default, the suggested interval is 10 minutes long, which is appropriate for most cases. Only in very specific cases it will be insufficient. You can recover from a 10 minutes loss, can you?

But there are cases where you should enlarge or reduce this interval. There is a tradeoff to be made:

  • Saving recovery info takes its time and uses computer resources. You will probably be able to identify when it's being done, even if it's done on the background. If the file is large, it will consume some time and will affect the machine performance, even if not by much;
  • The shorter the interval, the safer you are about recovery, but the greater the impact on your work and the PC performance;

If you're working on a normal size document, leave the default 10 minutes interval. On large documents, increase the interval to avoid a constant performance hit. Try a small increase to see if it is enough and enlarge again if it still impacts too much your regular work. Don't increase too much at once, because you're increasing your loss in case of failure.

If you're working on an unstable machine (with a history of crashing) or on a sensitive file, with a huge number of changes, and the file size is manageable, the reduce it to what is viable without disrupting regular work.

The rule is: leave it on the default 10 minutes setting unless you have a valid reason to change it, to either  a larger or smaller interval.

How it Works  - Step by Step for Word

1) Select Options from the Tools menu:

2) Select the Save separator. Activate the Save AutoRecover info every: and enter the selected interval in minutes (see above for some rules):

How it Works  - Step by Step for PowerPoint

1) Select Options from the Tools menu:

2) Select the Save separator. Activate the Save AutoRecover info every: and enter the selected interval in minutes (see above for some rules):

How it Works  - Step by Step for Excel

Excel is a complicated case. There is no standard option to AutoSave files. You need to install an Add-In that comes with the installation CD from Microsoft®. We will show how to install the add-in later, in case it's not already active.

How to Activate the Autosave after the Add-In is ready:

1) Select AutoSave from the Tools menu:

2) Enter the selected interval in minutes (see above for some rules). We advise you to turn off the Prompt Before Saving option, otherwise you'll get a disrupting prompt every time the AutoSave interval is reached. There is also an option to Save All open workbooks or only the one you're working. Select the more appropriated for your work in progress:

How to install the AutoSave Add-In if it's not present on the Tools menu:

1) Select Add-Ins from the Tools menu:

2) Enable the AutoSave Add-In and press the OK button (you may need the Microsoft® Office installation CD):

Can I know more about this subject ?

Check our FREE PC Tips and Tutorials. They will be regularly published. Better still, subscribe our Email Newsletter. You will be informed when contents updates are made and automatically granted participation on any future promotion.

Get FREE PC TIPS every month:

 


AutoSave Documents in Microsoft® Office - Version 1.00

Tested on Microsoft® Office® General Versions: 2000 (9.0), XP (10.0), 2003 (11.0) - should work on any version from Office 97


Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz