| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I use autosave from excel2000 in excel2003
I have just upgraded from excel 2000 to excel 2003 I have always set autosave
to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#2
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Claude
This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#3
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
First, I've never had any trouble with autosave crashing excel--but I don't use
it. I don't want anything saving my files but me. (I save often.) Saved from a previous post: If you can find a copy of the autosave addin from an earlier version, it should work ok. But xl2002+ has something called autorecovery. It's not the same as autosave, but will allow you to recover files if excel/windows crashes. As an alternative, you may want to consider using Jan Karel Pieterse's addin called AutoSafe (note spelling). 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, not autosafeVBE.zip, for your purposes.) Jan Karel's version will know if there was a crash and prompt you to open the last version it saved. === And Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm Claude J Johnson CPA Australia wrote: I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
AUUUGGGGG, I always used autosave in both word and excel. I too have multiple
files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
An even better workaround is to train your fingers to hit CTRL-s every
time you pause. It wasn't necessarily easy, but I haven't lost more than a minute or two's work in several years. In article , "karrenb" wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Gord Dibben posted this:
Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm ========== You can put it in the addin folder or you can just browse for that location via the tools|addins dialog. karrenb wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Ok Nevermind using Autosafe. It is simply the same as AutoRecovery. CAn
anyone help me with an autosave program?????? "karrenb" wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
THANK YOU. I HAVE DOWNLOADED IT SET MY TIMING AND AM ALL SET. THANKS, THANKS,
THANKS........NOW ANYONE WITH A MIRACLE WAY TO GET BACK MY LOST WORK??? "Dave Peterson" wrote: Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm ========== You can put it in the addin folder or you can just browse for that location via the tools|addins dialog. karrenb wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time -- Dave Peterson |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Karren
JK's autosafe is not the same as autorecovery. You can store the incremental backups in a folder of your choice and then dump them to the Recycle bin for you to recover the latest from the list after you have closed the file. Autorecovery does not allow that. See Dave's post about downloading AUTOSAVE.XLA Gord Dibben Excel MVP On Wed, 7 Dec 2005 14:37:03 -0800, "karrenb" wrote: Ok Nevermind using Autosafe. It is simply the same as AutoRecovery. CAn anyone help me with an autosave program?????? "karrenb" wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
I think you'll have to ask Santa. And I wouldn't stay up waiting for that
present! karrenb wrote: THANK YOU. I HAVE DOWNLOADED IT SET MY TIMING AND AM ALL SET. THANKS, THANKS, THANKS........NOW ANYONE WITH A MIRACLE WAY TO GET BACK MY LOST WORK??? "Dave Peterson" wrote: Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm ========== You can put it in the addin folder or you can just browse for that location via the tools|addins dialog. karrenb wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time -- Dave Peterson -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
To Gord Dibbon
I put your response into place and now have the old autosave working with excel 2003 just as I had in previous versions Having more than one computer i went to the library file of another computer and copied it over I have had no trouble since and we have been working for about a month Many thanks for the advice and I am passing your advice on to others Many thanks Claude "Gord Dibben" wrote: Karren JK's autosafe is not the same as autorecovery. You can store the incremental backups in a folder of your choice and then dump them to the Recycle bin for you to recover the latest from the list after you have closed the file. Autorecovery does not allow that. See Dave's post about downloading AUTOSAVE.XLA Gord Dibben Excel MVP On Wed, 7 Dec 2005 14:37:03 -0800, "karrenb" wrote: Ok Nevermind using Autosafe. It is simply the same as AutoRecovery. CAn anyone help me with an autosave program?????? "karrenb" wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Thanks for the feedback Claude.
Now I'll have lots of cellmates<g Gord On Fri, 9 Dec 2005 12:25:02 -0800, Claude J Johnson CPA Australia . com wrote: To Gord Dibbon I put your response into place and now have the old autosave working with excel 2003 just as I had in previous versions Having more than one computer i went to the library file of another computer and copied it over I have had no trouble since and we have been working for about a month Many thanks for the advice and I am passing your advice on to others Many thanks Claude "Gord Dibben" wrote: Karren JK's autosafe is not the same as autorecovery. You can store the incremental backups in a folder of your choice and then dump them to the Recycle bin for you to recover the latest from the list after you have closed the file. Autorecovery does not allow that. See Dave's post about downloading AUTOSAVE.XLA Gord Dibben Excel MVP On Wed, 7 Dec 2005 14:37:03 -0800, "karrenb" wrote: Ok Nevermind using Autosafe. It is simply the same as AutoRecovery. CAn anyone help me with an autosave program?????? "karrenb" wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#13
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Thank you - I was about to ask a similar question, I am just very happy you
guys already posted the answer. I did it, and now I have autosave back. THANK YOU AGAIN IT'S NOT THE SAME AS AUTO RECOVERY IT'S SO MUCH MORE. "Dave Peterson" wrote: Gord Dibben posted this: Autosave.xla from Office 2000 or 97 will work with Excel 2002 or 2003. If you have a previous copy, move it to your Office\Library. To download the 97 version see here........ http://www.stat.jmu.edu/trep/Marchat/sp2001/Library.htm ========== You can put it in the addin folder or you can just browse for that location via the tools|addins dialog. karrenb wrote: AUUUGGGGG, I always used autosave in both word and excel. I too have multiple files open at the same time. Today, someone working on my computer closed excel and said no when asked to save. As a result all of my changes were lost. I had thought that by setting autorecovery I was safe, but since this was not a crash but a clean exit, my work is lost. AUTORECOVERY is NOT better than auto save. WHY oh WHY did Microsoft take this away!!!! HELP Please. I will try the suggested Jan Karel version. My IT guy hates us trying stuff like this, but I desperately need an autosave function. Karren "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time -- Dave Peterson |
|
#14
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
Nick:
I haven't had to use autorecovery or autosave yet but as a very large file is involved, I need to know if anything happens to this file, the data will be recovered successfully. Your previous reply was helpful but could you please elaborate on: "save a temp file at the duration to a location shown on the same tab" - ie: where would this temp file be? What would it be called? What is the same tab? Thank you for your consideration of this request. joan "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time |
|
#15
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How can I use autosave from excel2000 in excel2003
If you're using Excel 2002 or 2003, 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 Autosave 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. 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 on 2002 and 2003 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 which also doen't alert before saving. 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 MS Excel MVP On Tue, 28 Nov 2006 08:54:02 -0800, still learning wrote: Nick: I haven't had to use autorecovery or autosave yet but as a very large file is involved, I need to know if anything happens to this file, the data will be recovered successfully. Your previous reply was helpful but could you please elaborate on: "save a temp file at the duration to a location shown on the same tab" - ie: where would this temp file be? What would it be called? What is the same tab? Thank you for your consideration of this request. joan "Nick Hodge" wrote: Claude This was an add-in in XL2000 and was incorporated and vastly improved in 2002/3. I could never successfully stop the old add-in from crashing excel so worked without back-up support The new version can have it's duration set via ToolOptions...Save to different times , default - 10 mins. What Excel then does is save a temp file at the duration to the location shown on the same tab. If you close excel and no error/crash has occurred then excel wipes the temp file. If you don't close Excel then you can go to this location, add an .xls extension to the file you find and it will open. The new version is *vastly* improved and knowing the above, is there any reason to need the old add-in? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England www.nickhodge.co.uk HIS "Claude J Johnson CPA Australia" <Claude J Johnson CPA wrote in message ... I have just upgraded from excel 2000 to excel 2003 I have always set autosave to 5 minutes in case I press the wrong button as I did tonight. I also had autosave set to save all open workbooks I am a heavy user of excel and often have many workbooks open at the one time Gord Dibben MS Excel MVP |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Opened Autosave but when closing workbook Autosave closes itself | Excel Worksheet Functions | |||
| AutoSave: How can I get it to save every 5 minutes & NO prompt? | Excel Worksheet Functions | |||
| Autosave options in Excel 2000 | Excel Discussion (Misc queries) | |||
| Can you recover Excel files accidently closed using autosave? | Excel Discussion (Misc queries) | |||
| excel2000 owc doesn't work on excel2003 ! | Excel Discussion (Misc queries) | |||
Linear Mode
