Excel and Auto Save

[Guest]

When Excel is set up to Auto Save every ten minutes, does it only save if there is an error and the computer shuts down or should all of this information be saved.

Example...we have a spreadsheet that is on our network. It is set up to autosave every 10 minutes. A particular user closed the May sheet that she was working on and when she went back in to it she lost everything that she had put in since 7 a.m. this morning. When she closed it, it did not ask her to save. She called our IS people and they said that Auto Save only works if the computer closes without being shut down properly. Is this true?

TIA

 

[Doug Kanter]

When Excel is set up to Auto Save every ten minutes, does it only save if

there is an error and the computer shuts down or should all of this
information be saved.

Example...we have a spreadsheet that is on our network. It is set up to

autosave every 10 minutes. A particular user closed the May sheet that she
was working on and when she went back in to it she lost everything that she
had put in since 7 a.m. this morning. When she closed it, it did not ask
her to save. She called our IS people and they said that Auto Save only
works if the computer closes without being shut down properly. Is this
true??

TIA

It saves every x number of minutes, depending on how you've set it up. It is
NOT related to whether or not the computer shut down correctly or not.

Direct from the Excel 2000 help file:
Save workbooks automatically as you work
1.. On the Tools menu, click AutoSave.
If the AutoSave command is not on the Tools menu, you must install the
AutoSave add-in.

How?

2.. Select the Automatic save every check box.


3.. In the Minutes box, enter how often you want Microsoft Excel to save
workbooks.


4.. Select any other options you want.

 

[Gord Dibben]

Denise

That would depend upon which version of Excel you are using. Always best to
state that info.

XL2002....has Autorecovery, which does not make incremental saves but if Excel
crashes you can recover the file to the last spot in the autorecovery
cycle(you can set that in Tools>Options>Save). If Excel does not crash, the
autorecovery temp file is deleted when workbook is closed.

Earlier versions had an Autosave add-in which made incremental saves at the
time of your choosing. Once saved, there is no going back.

The AUTOSAVE.XLA from earlier versions works fine with Excel 2002.

I have tried the version from Excel 97 and it works fine.

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe

It doesn't overwrite the existing workbook when it saves. It saves a copy 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.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)

Gord Dibben Excel MVP

Gord Dibben Excel MVP

 

[gman26]

How do you set-up the AUTOSAVE.XLA ?
I have a workbook that I want to save every 5 or 10 minutes. I want i
to save a ll the workbooks, not the AutoRecovery

 

[gman26]

How do you set-up the AUTOSAVE.XLA ?
I have a workbook that I want to save every 5 or 10 minutes. I want i
to save a ll the workbooks, not the AutoRecovery

 

[Gord Dibben]

gman

That would depend upon which version of Excel you are running.

There is no Autosave in XL2002 and 2003 as there was in earlier versions.

Autorecovery is it. This is not the same as Autosave.

BTW.....Dave Peterson reports that he tried an earlier version of Autosave.xla
in XL2002 and it seemed to work fine.

I have also tried the Autosave.XLA from XL97 and does the job.

To download the 97 version go here.....

http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm

In addition to the above......Jan Karel Pieterse has an addin called AutoSafe

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.

http://www.jkp-ads.com/Download.htm

(look for AutoSafe.zip)

Gord Dibben Excel MVP