Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
I remember a time where I could set up Excel to be saving the file in the
background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
You are right. Auto recovery option is meant for recovering from problems...
I don't have access to Excel 2003 now so can no test but I recall that functionality was same in Excel 2003... if you auto saved and quit without saving you got your original file back... Of course you can have a macro 'auto saving' then you will have the last save back... "turp2tri" wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
AutoSave add-in has not been available since Excel 2000 version.
Jan Karel Pieterse has an addin called AutoSafe which doen't alert before saving. http://www.jkp-ads.com/download.asp (look for AutoSafe.zip) download version 3.5 It doesn't overwrite the existing workbook when it saves. It saves a timed 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. If you still have access to the AutoSave add-in from Excel 2000 I believe it does work with 2007................it works with 2002 and 2003 I can send you a copy of Excel 97 AutoSave add-in which I know works well with 2003 version. Note: you can FileSave AsToolsGeneral OptionsAlways create a backup which will leave you with a *.XLK file that is always one version behind the current workbook. Gord Dibben MS Excel MVP On Fri, 7 Nov 2008 11:03:02 -0800, turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
Autorecovery was added in xl2002 and autosave.xla was removed.
But if you still have a copy of the autosave.xla from xl97 or xl2k, then they'll work with xl2002+. turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
ps.
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 turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
Unfortunately that link seems to have been removed.
I can't get in amymore.................gateway timeout. Gord On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson wrote: ps. 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 turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
That's too bad.
Maybe the OP still has access to the older version of Office. Gord Dibben wrote: Unfortunately that link seems to have been removed. I can't get in amymore.................gateway timeout. Gord On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson wrote: ps. 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 turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. -- Dave Peterson |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
I did offer to send a copy of the Excel 97 autosave add-in.
See what transpires. Gord On Fri, 07 Nov 2008 16:34:55 -0600, Dave Peterson wrote: That's too bad. Maybe the OP still has access to the older version of Office. Gord Dibben wrote: Unfortunately that link seems to have been removed. I can't get in amymore.................gateway timeout. Gord On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson wrote: ps. 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 turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Save while I work
I didn't notice that.
That's nice of you. Gord Dibben wrote: I did offer to send a copy of the Excel 97 autosave add-in. See what transpires. Gord On Fri, 07 Nov 2008 16:34:55 -0600, Dave Peterson wrote: That's too bad. Maybe the OP still has access to the older version of Office. Gord Dibben wrote: Unfortunately that link seems to have been removed. I can't get in amymore.................gateway timeout. Gord On Fri, 07 Nov 2008 15:01:39 -0600, Dave Peterson wrote: ps. 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 turp2tri wrote: I remember a time where I could set up Excel to be saving the file in the background as I worked (different from the current save for auto recovery functionality that only works after loos of power, etc) and I could close the file without manually saving changes as I worked and know that if I re-opened it, I would have the version that was "auto-saved" 5 minutes ago. Is that capability gone or am I missing how to do it in 2007? Thanks. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i recover work that it did not save | Excel Discussion (Misc queries) | |||
"Save as" will not work when trying to save a document in a folder | Excel Discussion (Misc queries) | |||
I wish to save my Excell work in my work sheets | Excel Worksheet Functions | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
Why doesn't Save as work over the network? | Excel Discussion (Misc queries) |