MoonPoint Support Logo

 


Shop Amazon Warehouse Deals - Deep Discounts on Open-box and Used ProductsAmazon Warehouse Deals



Advanced Search
March
Sun Mon Tue Wed Thu Fri Sat
  1
     
2021
Months
Mar
Dec


Mon, Mar 01, 2021 9:44 pm

Changing the AutoRecover frequency for Microsoft Excel 2007

Microsoft Excel 2007 crashed on a laptop running Windows 10 that I was using. When I restarted Excel, I found that, unfortunately, I had lost all of the recent changes I had made to a spreadsheet, even though Excel put "(version 1).xlsb [Autosaved]" in the title of the spreadsheet I had been working on when I restarted Excel—-it crashed when I attempted to paste a webpage URL into a Hyperlink field. The crash and loss of my recent work was aggravating, so I decided to change the frequency with which Excel auomatically saves a file in an AutoRecover version that will allow you to automatically recover a document if if the program hangs or crashes. To change that setting for Excel 2007 on a Windows system, you can click on the Office Button at the top, left-hand corner of the Excel window (it is to the left of the "Home" tab as shown below).

Excel - Office Button

Then click on the Excel Options button and select the Save option. The checkbox for "Save AutoRecover information every" should be checked. You can then change the frequency from 10 minutes to a more frequent number; I chose to have Excel automatically save a document every 5 minutes.

Excel 2007 AutoRecover Frequency

[/software/office/excel] permanent link

Once You Know, You Newegg AliExpress by Alibaba.com

Shop Amazon Local - Subscribe to Deals in Your Neighborhood

Valid HTML 4.01 Transitional

Privacy Policy   Contact

Blosxom logo