Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I set up auto save on shared workbook , but it does'nt work
thank Ziad |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Please explain how you did this and what you expect to occur.
What version of Excel are you running that you believe has an "autosave" function? Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 09:16:02 -0800, ziad wrote: I set up auto save on shared workbook , but it does'nt work thank Ziad |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I went to tool and I create a shared workbook , for 5 users, every one
update this workbook, and I set up auto save by going to tools option save evry one minute but it doesn't work. I want to set up also beep when one of us update the workbook . Thanks Ziad "Gord Dibben" wrote: Please explain how you did this and what you expect to occur. What version of Excel are you running that you believe has an "autosave" function? Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 09:16:02 -0800, ziad wrote: I set up auto save on shared workbook , but it does'nt work thank Ziad |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You haven't stated what version of Excel you are using.
Versions later than 2000 do not have an "autosave" feature. 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 On Fri, 4 Jan 2008 06:47:00 -0800, ziad wrote: I went to tool and I create a shared workbook , for 5 users, every one update this workbook, and I set up auto save by going to tools option save evry one minute but it doesn't work. I want to set up also beep when one of us update the workbook . Thanks Ziad "Gord Dibben" wrote: Please explain how you did this and what you expect to occur. What version of Excel are you running that you believe has an "autosave" function? Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 09:16:02 -0800, ziad wrote: I set up auto save on shared workbook , but it does'nt work thank Ziad |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am sory I forget to tell that I have excell 3000 version.
so how I can have auto save like the old version , because I want to made true incremental saves at intervals and alerted me before saving? Thanks Ziad "Gord Dibben" wrote: You haven't stated what version of Excel you are using. Versions later than 2000 do not have an "autosave" feature. 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 On Fri, 4 Jan 2008 06:47:00 -0800, ziad wrote: I went to tool and I create a shared workbook , for 5 users, every one update this workbook, and I set up auto save by going to tools option save evry one minute but it doesn't work. I want to set up also beep when one of us update the workbook . Thanks Ziad "Gord Dibben" wrote: Please explain how you did this and what you expect to occur. What version of Excel are you running that you believe has an "autosave" function? Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 09:16:02 -0800, ziad wrote: I set up auto save on shared workbook , but it does'nt work thank Ziad |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 3000 does not exist.
Please re-read my post for details on a couple of methods to make incremental saves. Gord On Fri, 4 Jan 2008 12:50:00 -0800, ziad wrote: I am sory I forget to tell that I have excell 3000 version. so how I can have auto save like the old version , because I want to made true incremental saves at intervals and alerted me before saving? Thanks Ziad "Gord Dibben" wrote: You haven't stated what version of Excel you are using. Versions later than 2000 do not have an "autosave" feature. 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 On Fri, 4 Jan 2008 06:47:00 -0800, ziad wrote: I went to tool and I create a shared workbook , for 5 users, every one update this workbook, and I set up auto save by going to tools option save evry one minute but it doesn't work. I want to set up also beep when one of us update the workbook . Thanks Ziad "Gord Dibben" wrote: Please explain how you did this and what you expect to occur. What version of Excel are you running that you believe has an "autosave" function? Gord Dibben MS Excel MVP On Thu, 3 Jan 2008 09:16:02 -0800, ziad wrote: I set up auto save on shared workbook , but it does'nt work thank Ziad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
auto save | Excel Discussion (Misc queries) | |||
Auto save | Excel Discussion (Misc queries) | |||
Auto Save???? | Excel Worksheet Functions | |||
Auto Save | Excel Discussion (Misc queries) | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) |