![]() |
Autosaves not for recovery
Is there an add-in for Excel 2003 and 2007 that will set up a save back to
the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie |
Autosaves not for recovery
Autosafe by Jan-Karel Pieterse, since you are using it commercially you
might want to donate something if it fits the bill http://www.jkp-ads.com/download.asp -- Regards, Peo Sjoblom "Bettie Claxton" wrote in message ... Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie |
Autosaves not for recovery
The autosave addin that worked for xl2k will work in xl2003.
And I bet that it still works in xl2007--but I haven't tested. Bettie Claxton wrote: Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie -- Dave Peterson |
Autosaves not for recovery
I looked at autsafe and it will only save to another file name. We could
make that work but would have re-educate all if we go that route. Thanks for the suggestions. -- Bettie "Peo Sjoblom" wrote: Autosafe by Jan-Karel Pieterse, since you are using it commercially you might want to donate something if it fits the bill http://www.jkp-ads.com/download.asp -- Regards, Peo Sjoblom "Bettie Claxton" wrote in message ... Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie |
Autosaves not for recovery
Thanks, I'll try it and let you know.
-- Bettie "Dave Peterson" wrote: The autosave addin that worked for xl2k will work in xl2003. And I bet that it still works in xl2007--but I haven't tested. Bettie Claxton wrote: Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie -- Dave Peterson |
Autosaves not for recovery
I finally got a chance to test this and you are right. It works very well in
both Excel 2003 and Excel 2007. Thank you again. -- Bettie "Dave Peterson" wrote: The autosave addin that worked for xl2k will work in xl2003. And I bet that it still works in xl2007--but I haven't tested. Bettie Claxton wrote: Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie -- Dave Peterson |
Autosaves not for recovery
Thanks for posting back with your results.
Bettie Claxton wrote: I finally got a chance to test this and you are right. It works very well in both Excel 2003 and Excel 2007. Thank you again. -- Bettie "Dave Peterson" wrote: The autosave addin that worked for xl2k will work in xl2003. And I bet that it still works in xl2007--but I haven't tested. Bettie Claxton wrote: Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie -- Dave Peterson -- Dave Peterson |
Autosaves not for recovery
I have to correct myself. I've learned through further testing that this
add-in works for 2007/2003 if you select to save only the current workbook. It does not work if you say to save all workbooks. We have a user who has multiple spreadsheets that are being updated from a data source and need to be saved frequently. We figured out this workaround. He opens one spreadsheet that is set it to save the current workbook only. Once an automatic save has occurred, he opens the second spreadsheet and the autosave function will work on that spreadsheet as well for several hours. When he sees that the saving has stopped, he closes both spreadsheets and restarts them one at a time. -- Bettie "Dave Peterson" wrote: Thanks for posting back with your results. Bettie Claxton wrote: I finally got a chance to test this and you are right. It works very well in both Excel 2003 and Excel 2007. Thank you again. -- Bettie "Dave Peterson" wrote: The autosave addin that worked for xl2k will work in xl2003. And I bet that it still works in xl2007--but I haven't tested. Bettie Claxton wrote: Is there an add-in for Excel 2003 and 2007 that will set up a save back to the same file name versus the recovery file that gets deleted when you closed Excel. We had one for Excel 200 that did this. The reason for the need is that we have a spreasheet that is updated automatically from the Internet. We write it back to the disk every five minutes, so that people in all of our offies can see the latest prices within a 5 minutes span. The Excel 200 add-in did this for us nicely. I want to move all to 2007, but I must have some way to really save the file back to itself automatically. Does anyone know of one? -- Bettie -- Dave Peterson -- Dave Peterson |
All times are GMT +1. The time now is 05:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com