ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How do I set an autosave in Excel 2007 (https://www.excelbanter.com/setting-up-configuration-excel/92665-how-do-i-set-autosave-excel-2007-a.html)

Alicia

How do I set an autosave in Excel 2007
 
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

How do I set an autosave in Excel 2007
 
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
HIS


"Alicia" wrote in message
...
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!




Gord Dibben

How do I set an autosave in Excel 2007
 
Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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



Nick Hodge

How do I set an autosave in Excel 2007
 
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
HIS


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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





Alicia

How do I set an autosave in Excel 2007
 
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" wrote:

Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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




Gord Dibben

How do I set an autosave in Excel 2007
 
I have no idea how Office 2007 is structured.

Wait for someone else to jump in.

Thanks, Gord

On Thu, 8 Jun 2006 08:00:01 -0700, Alicia
wrote:

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" wrote:

Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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




Gord Dibben MS Excel MVP

Nick Hodge

How do I set an autosave in Excel 2007
 
Alicia

To load an add-in in XL2007 go to Office ButtonExcel
Options...Add-InsManage 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
HIS


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have no idea how Office 2007 is structured.

Wait for someone else to jump in.

Thanks, Gord

On Thu, 8 Jun 2006 08:00:01 -0700, Alicia

wrote:

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" wrote:

Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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



Gord Dibben MS Excel MVP




Alicia

How do I set an autosave in Excel 2007
 
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" wrote:

Alicia

To load an add-in in XL2007 go to Office ButtonExcel
Options...Add-InsManage 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
HIS


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have no idea how Office 2007 is structured.

Wait for someone else to jump in.

Thanks, Gord

On Thu, 8 Jun 2006 08:00:01 -0700, Alicia

wrote:

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" wrote:

Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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



Gord Dibben MS Excel MVP





Nick Hodge

How do I set an autosave in Excel 2007
 
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
HIS


"Alicia" wrote in message
...
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" wrote:

Alicia

To load an add-in in XL2007 go to Office ButtonExcel
Options...Add-InsManage 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
HIS


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
I have no idea how Office 2007 is structured.

Wait for someone else to jump in.

Thanks, Gord

On Thu, 8 Jun 2006 08:00:01 -0700, Alicia

wrote:

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" wrote:

Nick

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

Autorecovery from ToolsOptionsSave 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

On Wed, 7 Jun 2006 20:57:45 +0100, "Nick Hodge"
wrote:

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



Gord Dibben MS Excel MVP







Gord Dibben

How do I set an autosave in Excel 2007
 
Autosafe by JK when first loaded through ToolsAdd-ins pops up a dialog allowing
a path to be set, interval, language and others.


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 20:35:46 +0100, "Nick Hodge"
wrote:

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



Alicia

How do I set an autosave in Excel 2007
 
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" wrote:

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


Gord Dibben MS Excel MVP

On Mon, 12 Jun 2006 20:35:46 +0100, "Nick Hodge"
wrote:

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




guy007

How do I set a master default in office 2003
 


Gord Dibben

How do I set a master default in office 2003
 
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

On Sat, 1 Sep 2007 05:20:00 -0700, guy007
wrote:




All times are GMT +1. The time now is 03:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com