Home |
Search |
Today's Posts |
#1
|
|||
|
|||
AutoSave: How can I get it to save every 5 minutes & NO prompt?
Have read several good answers regarding AutoSave but can't get mine to make
any changes. Using WinXP PRO - O.S. and brought the AutoSave in from W/2000 Excel/ Works good / BUT it's set for 10 Minutes and "Prompt for Save". Want to change it to save every 5 minuters and NO PROMPT to SAVE, Just automatically save it. Anyone know the secret to getting a permanent change done as I've tried just about everything-Gone to Tools, Options, Save / Edit, Etc., and done other things - BUT - No Results as to making the change permanent from 10 Minutes and to Prompt TO 5 Minutes and NO PROMPT. I've changed it just about every time I open Excel to 5 Minutes and NO PROMPT BUT it always comes back to the 10 Minutes and PROMPT. All help appreciated. Thanks /Valerie / |
#2
|
|||
|
|||
Valerie
Office 2000 Autosave had a bug which was corrected in a Service Release. Try the advice below from Dave Peterson............ Dave Peterson Jul 21 2004, 6:49 pm Maybe... http://support.microsoft.com/default...b;en-us;231117 XL2000: AutoSave Settings Are Not Retained Between Sessions of Excel 2000 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.) Gord Dibben Excel MVP On Tue, 27 Sep 2005 13:58:04 -0700, "Valerie" wrote: Have read several good answers regarding AutoSave but can't get mine to make any changes. Using WinXP PRO - O.S. and brought the AutoSave in from W/2000 Excel/ Works good / BUT it's set for 10 Minutes and "Prompt for Save". Want to change it to save every 5 minuters and NO PROMPT to SAVE, Just automatically save it. Anyone know the secret to getting a permanent change done as I've tried just about everything-Gone to Tools, Options, Save / Edit, Etc., and done other things - BUT - No Results as to making the change permanent from 10 Minutes and to Prompt TO 5 Minutes and NO PROMPT. I've changed it just about every time I open Excel to 5 Minutes and NO PROMPT BUT it always comes back to the 10 Minutes and PROMPT. All help appreciated. Thanks /Valerie / |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Option in Excel to save a close a workbook inactive for 5 minutes | Excel Discussion (Misc queries) | |||
auto save excel file every 10 minutes to its original file name | Excel Discussion (Misc queries) | |||
Save as Msg box | Excel Discussion (Misc queries) | |||
How do I have excel save a copy every _ minutes ONLY in the even. | Excel Discussion (Misc queries) | |||
Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) |