Solved

Excel - Auto Save

Posted on 2011-02-20
5
403 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
ID: 34939418
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
ID: 34939580
@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
ID: 34939614
This is where I have it in my MS Office this one :)
0
 
LVL 30

Expert Comment

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

Sid
0
 

Author Closing Comment

by:tahirih
ID: 34944085
Thank you!
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

685 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