In short, unless you have a specific need to use FastSave such as if you are only creating simple documents using Word 6 on a slow machine , it is probably a good idea to turn it off. The FastSave feature is turned on by default in all versions of Word, even in the original Word Only if you are using Word 97 SR-1 is it turned off by default.
As a side note, according to the Microsoft Knowledge Base there are several circumstances under which a FastSave is not done by Word, even if you have enabled the feature. These circumstances include the following:. I'm creating a database of employees in MS Excel which I have saved in D: partition of the hard disk.
But as a security of my file I want to keep an option which will automatically backup the file in H: my External Hard disk. Is there any option to save file in MS Excel such that every time I input new data in that excel file and click the SAVE button,the backup file of that excel file in External Hard disk is automatically updated.
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question They offer the Save file and create backup tool that helps you create multiple backup versions of your document. Once you install these utilities in Excel, you can use a special keyboard shortcut to save your workbook and automatically create a backup copy. Each version has a timestamp in the file name, so you can easily find the necessary copy according to the date and time it was created.
Just copy it from this article and paste into the code Module. You can create as many backup copies as you want just by pressing a simple shortcut.
It will restore a previously saved version of your workbook and won't overwrite any old backup file. Each copy is marked with a date and time of backup. For those who use cloud storage services for saving their docs, retrieving overwritten Excel files won't be a problem at all. Let's have a closer look at OneDrive , Microsoft's storage option.
Its biggest strength is that OneDrive is closely tied with Office. As an example, you can quickly open and save OneDrive documents right from your Excel. OneDrive and Excel work together to sync workbooks faster and let you work with other people on shared documents at the same time. When you or your colleague makes changes to a document, OneDrive keeps track of the versions automatically, so you don't need to store multiple copies of the same document. With OneDrive's Version history you'll be able to see the earlier variants of the file, you'll know when the document was modified and who made the changes.
You can also restore any of the previous versions if necessary. Another very popular cloud storage service is Dropbox. It keeps snapshots of every change in your Dropbox folder over the last 30 days. So even if you saved a bad change, or if the file has been damaged or deleted, you can restore the document to an older version with only a few clicks. Dropbox doesn't work so closely with Microsoft Office as OneDrive, but it is so simple that everybody can master it. This allows you to go back to the backup, in case you accidentally delete something or make unwanted changes in the working File.
Every time you save the original file, the backup file is also updated. This practically means that the backup copy is always going to be one version behind the current status of the Excel file that you are working on. Click on the File tab located in the top menu bar.
The backup is identified by the. Although the extension makes it a little bit easier to locate the backup file, it should be easy for you to find the file because they are named differently. And then if you need to, you could actually open up this backup file which would reflect the changes prior to the last time the file was saved.
If you open the Excel backup file, you may be prompted to confirm you want to open the file.
0コメント