How do I set an autosave in Excel 2007

[Alicia]

I am trying the Beta version of Office 2007 and wanted to know if there was
an autosave feature in Excel - Office 2003 did not have this and that was
very annoying!

 

[Nick Hodge]

Alicia

Excel has had autosave since XL2000. In that release it was an add-in, it
was brought into the product as a standard feature in Excel 2002 (XP) so of
course it's been in Excel 2003 and XL2007 too. It's on by default.

You can look at the settings from the 'Office Button'>Excel Options...Save

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Gord Dibben]

Nick

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

Autorecovery from Tools>Options>Save is it. This is not the same as the
Autosave Add-in which made true incremental saves at intervals and alerted you
before saving.

Autorecovery just saves a temporary file which it deletes if Excel closes
normally without incident.

Alicia..........As far as Excel 2007...........I have no idea if the
AUTOSAVE.XLA from Excel 2000 will function as it did in 2002 and 2003, if you
can get your hands on a copy


Gord Dibben MS Excel MVP

 

[Nick Hodge]

Gord

Yes, subtle difference I didn't pick up, although my experience with the xla
was always bad, so I never used it, (crashed the app continuously when
trying to save during other operations). The auto-recovery, which is really
what Word, etc does is far more intuitive, granted it doesn't save a copy
come what may, but maybe as I save regularly, or often start with a save
as... I don't often have problems.

Interestingly, since we have had Win 2003 server at work, you can simply
restore previous versions by right clicking the file and choosing from any
twice a day autosaved versions from the last five days.

I suspect the old xla will work just as it did under 2002/3???

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Alicia]

Gord, thank you - I found a similar thread you replied to with a link for '97
Autosave.xla and downloaded it.

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

My only problem now is how to access it through Excel 2007 as it's totally
different to any previous versions of Excel. If you have any ideas I would
appreciate it. There is an add-in tab but even after downloading autosave,
it just has the pdf capability under that section. Is there a specific place
I should be downloading the file to for Excel to automatically read it?

thanks again

Alicia

 

[Gord Dibben]

I have no idea how Office 2007 is structured.

Wait for someone else to jump in.

Thanks, Gord

Gord, thank you - I found a similar thread you replied to with a link for '97
Autosave.xla and downloaded it.

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

My only problem now is how to access it through Excel 2007 as it's totally
different to any previous versions of Excel. If you have any ideas I would
appreciate it. There is an add-in tab but even after downloading autosave,
it just has the pdf capability under that section. Is there a specific place
I should be downloading the file to for Excel to automatically read it?

thanks again

Alicia

Gord Dibben MS Excel MVP

 

[Nick Hodge]

Alicia

To load an add-in in XL2007 go to Office Button>Excel
Options...>Add-Ins>Manage Excel Add-Ins dropdown and select go... This
launches the 'old' dialog and you can navigate to the xla from here. Once
loaded it should show on the add-in tab

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Alicia]

Thank you very much Nick, have located the autosafe.xla and it's now included
in the list. I do just have one more question, sorry. Is there anyway to
specifiy with this file where it saves too and how often it will auto backup?

Thanks again for your help so far.

Alicia.

 

[Nick Hodge]

Alicia

I'm not sure I remember how it was 'set' in XL2000.

I only have XL2007 currently on this machine, so can't help

Can anyone prompt me/Alicia how this was set in XL2000 and it may give me
some clues

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Gord Dibben]

Autosafe by JK when first loaded through Tools>Add-ins pops up a dialog allowing
a path to be set, interval, language and others.


Gord Dibben MS Excel MVP

 

[Alicia]

Well, thank you guys for all your help, turns out that running autosafe
crashes excel 2007 so i had to get rid of it as an add-in - hey-ho! It was a
nice thought!

take care

 

[Gord Dibben]

First you would re-post with some details of what you mean by "master default".

Post your description in the body of the message please.


Gord Dibben MS Excel MVP