Solved

Excel - Auto Save

Posted on 2011-02-20
5
397 Views
Last Modified: 2012-08-13
Hi,

How can I configure Excel 2007 to auto save opened documents every specified number of minutes (e.g. save every 5 minutes).

Thank you
0
Comment
Question by:tahirih
  • 2
  • 2
5 Comments
 
LVL 6

Accepted Solution

by:
t-max earned 500 total points
Comment Utility
1 Click the "Office Button" on the top left side of your spreadsheet. Click "Excel Options."
2 Click "Save" on the left side of the "Excel Options" dialog box.
3 Check the box labeled "Save AutoRecover information every x minutes."
4 Select the time increment you wish to have Excel autosave your worksheets. This number ranges from one to 120 minutes.
5 Click "OK" at the bottom of the "Excel Options" box. This procedure enables autosave on this worksheet and every worksheet you create in the future.

0
 
LVL 30

Expert Comment

by:SiddharthRout
Comment Utility
@t-max>> 1 Click the "Office Button" on the top left side of your spreadsheet. Click "Excel Options."

You mean Bottom Right Side of the Office Menu :)

Sid
0
 
LVL 6

Expert Comment

by:t-max
Comment Utility
This is where I have it in my MS Office this one :)
0
 
LVL 30

Expert Comment

by:SiddharthRout
Comment Utility
I read it wrong :) I thought you were referring to the "Excel Options"

Sid
0
 

Author Closing Comment

by:tahirih
Comment Utility
Thank you!
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

744 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

16 Experts available now in Live!

Get 1:1 Help Now