![]() |
Excel wont autosave; how can i fix this?
My computer suddenly restarted while a word document and excel sheet were
open and office was set to autosave every 2 minutes so i didnt lose my work, I found the autosave file for word but there wasnt one for excel. will excel autosave? and how can i set it up that it will? |
Excel wont autosave; how can i fix this?
xl2002 added an autorecovery feature that can be turned on by the user. It
saves a copy of the workbook every xx minutes (user selectable). If excel/windows crashes, the next time you open excel, it sees that file and asks if you want to recover from the crash. Before xl2002, there was an autosave addin that you could use. It actually saved the file every xx minutes (againg selectable by the user). But it wasn't made to recover from crashes--it just saved right over the file. Jan Karel Pieterse wrote an addin (works in any version) 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 Kat wrote: My computer suddenly restarted while a word document and excel sheet were open and office was set to autosave every 2 minutes so i didnt lose my work, I found the autosave file for word but there wasnt one for excel. will excel autosave? and how can i set it up that it will? -- Dave Peterson |
Excel wont autosave; how can i fix this?
Thanks for the prompt response and i will def have a look at that AutoSafe
app but i have xl2003 so there should be an autosave file somewhere as it is set to autosave every 2 minutes; but i cant find it "Dave Peterson" wrote: xl2002 added an autorecovery feature that can be turned on by the user. It saves a copy of the workbook every xx minutes (user selectable). If excel/windows crashes, the next time you open excel, it sees that file and asks if you want to recover from the crash. Before xl2002, there was an autosave addin that you could use. It actually saved the file every xx minutes (againg selectable by the user). But it wasn't made to recover from crashes--it just saved right over the file. Jan Karel Pieterse wrote an addin (works in any version) 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 Kat wrote: My computer suddenly restarted while a word document and excel sheet were open and office was set to autosave every 2 minutes so i didnt lose my work, I found the autosave file for word but there wasnt one for excel. will excel autosave? and how can i set it up that it will? -- Dave Peterson |
Excel wont autosave; how can i fix this?
Autosave is not included in xl2002 or xl2003.
These versions use AutoRecovery--a solution for a different problem. Kat wrote: Thanks for the prompt response and i will def have a look at that AutoSafe app but i have xl2003 so there should be an autosave file somewhere as it is set to autosave every 2 minutes; but i cant find it "Dave Peterson" wrote: xl2002 added an autorecovery feature that can be turned on by the user. It saves a copy of the workbook every xx minutes (user selectable). If excel/windows crashes, the next time you open excel, it sees that file and asks if you want to recover from the crash. Before xl2002, there was an autosave addin that you could use. It actually saved the file every xx minutes (againg selectable by the user). But it wasn't made to recover from crashes--it just saved right over the file. Jan Karel Pieterse wrote an addin (works in any version) 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 Kat wrote: My computer suddenly restarted while a word document and excel sheet were open and office was set to autosave every 2 minutes so i didnt lose my work, I found the autosave file for word but there wasnt one for excel. will excel autosave? and how can i set it up that it will? -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 03:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com