Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
Can anyone help?
In Excel 2000 you could click on Tools and in the Add Ins list set your worksheets to Auto-Save every 10 minutes or so. I can't seem to find this in Excel 2007 has it been removed and is there any new way of Auto saving? Thanks in advance. -- Regards Warren |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
Version prior to Excel 2002 had a real AutoSave which overwrote the workbook
with a save at specified time intervals. Good or bad feature depending on how you look at it. Versions since 2000 use Auto Recovery which only creates a timed but temporary backup file which is deleted when the workbook is closed normally. Auto Recovery is a safety valve in the event of an Excel crash while a workbook is open. 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) 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. If you still have access to the AutoSave add-in from Excel 2000 it may work with 2007................it did work with 2002 and 2003 Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 06:36:17 -0700, Warren Easton wrote: Can anyone help? In Excel 2000 you could click on Tools and in the Add Ins list set your worksheets to Auto-Save every 10 minutes or so. I can't seem to find this in Excel 2007 has it been removed and is there any new way of Auto saving? Thanks in advance. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
1. Get the autosave.xla from a 2000 machine and see if it will work
2. Use an OnTime macro -- Gary''s Student - gsnu200800 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
Another PC in my group still has 2000 how would I copy this to my PC?
-- Regards Warren "Gord Dibben" wrote: Version prior to Excel 2002 had a real AutoSave which overwrote the workbook with a save at specified time intervals. Good or bad feature depending on how you look at it. Versions since 2000 use Auto Recovery which only creates a timed but temporary backup file which is deleted when the workbook is closed normally. Auto Recovery is a safety valve in the event of an Excel crash while a workbook is open. 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) 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. If you still have access to the AutoSave add-in from Excel 2000 it may work with 2007................it did work with 2002 and 2003 Gord Dibben MS Excel MVP On Thu, 14 Aug 2008 06:36:17 -0700, Warren Easton wrote: Can anyone help? In Excel 2000 you could click on Tools and in the Add Ins list set your worksheets to Auto-Save every 10 minutes or so. I can't seem to find this in Excel 2007 has it been removed and is there any new way of Auto saving? Thanks in advance. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
How do i copy the autosave.xla then put it on my machine?
-- Regards Warren "Gary''s Student" wrote: 1. Get the autosave.xla from a 2000 machine and see if it will work 2. Use an OnTime macro -- Gary''s Student - gsnu200800 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
Use Windows button|search to look for autosave.xla
Then copy it to a thumbdrive, floppy disk, or even email it to the other pc. Put it in your favorite folder and then use: Tools|addins to browse for that autosave.xla addin. Keep a backup copy somewhere safe--you may find it useful when you (or all of you!) get new pc's--or software upgrades! Warren Easton wrote: How do i copy the autosave.xla then put it on my machine? -- Regards Warren "Gary''s Student" wrote: 1. Get the autosave.xla from a 2000 machine and see if it will work 2. Use an OnTime macro -- Gary''s Student - gsnu200800 -- Dave Peterson |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
File/ Copy (or Control C)
File/ Paste (or Control V)/ choose an appropriate destination -- David Biddulph "Warren Easton" wrote in message ... How do i copy the autosave.xla then put it on my machine? -- Regards Warren "Gary''s Student" wrote: 1. Get the autosave.xla from a 2000 machine and see if it will work 2. Use an OnTime macro -- Gary''s Student - gsnu200800 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
FileCopy to portable media like a floppy.
Insert media in new machine. Copy to Office\Library folder Gord On Thu, 14 Aug 2008 09:12:13 -0700, Warren Easton wrote: Another PC in my group still has 2000 how would I copy this to my PC? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto-Save
Works perfectly.
Thank You very Much. -- Regards Warren "Dave Peterson" wrote: Use Windows button|search to look for autosave.xla Then copy it to a thumbdrive, floppy disk, or even email it to the other pc. Put it in your favorite folder and then use: Tools|addins to browse for that autosave.xla addin. Keep a backup copy somewhere safe--you may find it useful when you (or all of you!) get new pc's--or software upgrades! Warren Easton wrote: How do i copy the autosave.xla then put it on my machine? -- Regards Warren "Gary''s Student" wrote: 1. Get the autosave.xla from a 2000 machine and see if it will work 2. Use an OnTime macro -- Gary''s Student - gsnu200800 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 auto-recovery / auto-save? | Setting up and Configuration of Excel | |||
auto save | New Users to Excel | |||
Auto save | Excel Discussion (Misc queries) | |||
Auto Save???? | Excel Worksheet Functions | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) |