Is there an auto save in Office 2007 Excel


    Sponsored Links


  • 1. Error with page breaks in printing
    Hi - I have been working on the same spreadsheet for several days now - each day, another column of data is added and then sorted... last Friday, when I formatted the data to print, my normally 3 page document came out to be 185 pages. I cleared my page breaks to bring it back to 3 pages, and now those 3 pages will print - but in 30% mode - if I adjust the page back up to 75%, I get 185 pages again - I've tried forcing it to read 1 page by 3, but that doesn't work either - any ideas? Thanks! Scott
  • 2. Can't Find the file
    hai, when i double click the excel file it won't open but "Can't find the file 'D:test.xls'(or one of its components). Make sure the path and file name are correct and that all required libraries are available" message comes. but all other functionalities are working fine in Excel 2000. and also i double click the other than excel file it will open properly. Please help me
  • 3. Numerical Columns
    How do I change columns from a numerical value to alphabetical characters(A-Z, etc.)?
  • 4. all numbers are divided by 10
    On a blank worksheet, when I enter a number, it is automatically divided by 10. If I enter 123, it shows as 12.3

Is there an auto save in Office 2007 Excel

Postby SmVhbg » Wed, 05 Mar 2008 02:26:00 GMT

Is there a setting somewhere for a spreadsheet to automatically save every 10 
minutes, as there was an option in previous versions of Excel?

Re: Is there an auto save in Office 2007 Excel

Postby Roger Govier » Wed, 05 Mar 2008 02:51:05 GMT

Round Office button>Excel Options>Save>Save Auto-recover Information every x 

Roger Govier

Re: Is there an auto save in Office 2007 Excel

Postby Gord Dibben » Wed, 05 Mar 2008 07:38:58 GMT

Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals.  Good or bad feature depending on how
you look at it.

Versions since 2000 use Auto Recovery which only creates a timed but temporary
backup file which is deleted when the workbook is closed normally.

Auto Recovery is a safety valve in the event of an Excel crash while a workbook
is open.

Jan Karel Pieterse has an addin called AutoSafe 
which doen't alert before saving. 


(look for

It doesn't overwrite the existing workbook when it saves.  It saves to a user 
selectable folder.  And when it's done, it either deletes these backups (or 
puts them in the recycle bin).  And the user can always restore the backups 
from the recycle bin. 

Gord Dibben  MS Excel MVP

Similar Threads:

1.Excel 2007 auto-recovery / auto-save?

I have an large spreadsheet where the data is populated via a connection to 
databases via MS Query.  In addition to this data there are various lookup 
tables used to enhance the data downloaded from the query.  This issue that i 
am having is if i need to make an adjustment to one of the lookup tables 
excel appears to go into an auto-recovery process and this takes anywhere 
from 20-45 minutes depending on the server load at that time.  I have 
"excluded" the workbook from auto-recovery, turn the calculate option to 
"manual", disabled background error checking attempting to shut off whatever 
process is taking control of the workbook.  I believe it is the auto-recovery 
option as i forced the workbook closed via task manager and when i reopended 
the workbook it gave me a recovered version.  How can i stop this from 
occuring and be in control when i want to save, calc, etc.  I am using Visa 
Business Pro (SP1) and have installed SP1 of office.

2.I am activating Office 2007 & am getting the error product act

I have just managed to activate at last [Sunday at 05:20 GMT].  
Graham Lyons

"Rui Baptista" wrote:

> I have the same problem, now for 5 days!
> The functions are less now.
> "sfrazier" wrote:
> > I have not been able to active my Office 2007 download because the product 
> > activation system is down for maintenance and now I have limited 
> > functionality.  Is there an alternate way to activate?

3.Can I auto save to a separate file?(not the file I am working in)

I need to save my spread sheet every 30 minutes to another file that I am not 
working in, and this other file will not be saved over when I save to my 
working file.

4.I am using office 2003, is there a need to upgrade to office 2007

I am using office 2003 Professional Edition on windows vista SP1 and it seems 
to work fine. Have just purchased a new laptop with Windows Vista and am 
contemplating purchasing the Office 2007 Home and student version. Is this 
necessary or should i just stick to my professional office 2003 version?

5.Excel 2007 - Auto-Save is dsabled.

For some reason my Excel has disabled my auto-save feature and it is now 
greyed out and won't allow me to turn it back on. Every 10 minutes I get an 
error pop up that autosave failed.

Anyone know how to resolve this issue?


6. Excel 2007 Auto Save

7. Why still no AUTO SAVE in Excel 2007?

8. Is there any File Auto Save Function for Excel and Word 2007

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 93 guest