If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
autosave/add-ins
I'm not very familiar with Excel but have a couple of files out of necessity. Recently, as I was working on one, there was some kind of error and it had to close down Excel. To prevent me from losing further information in the future I want to set an Autosave time limit but it's not on my PC - So I go to Help and it tries to tell me how to put Autosave in through Add-ins but it didn't like something on my MS Office disc SR-1 disc 1 and now when I try to do the Add-in it doesn't respond and I still can't get Autosave!!! Any help greatly appreciated!
Frustrated! I realise something else might be wrong somewhere down the line and I hope to ask further questions later on but any help/ideas would be good for now... |
#2
|
|||
|
|||
autosave/add-ins
It's a personal thing, but I don't approve of using autosave with Excel.
I teach people to "Save early and save often". If you get used to that idea then, when you do save, you can also make other decisions such as whether to overwrite the existing file or save the current one to a new name, which helps provides a history. By using autosave you may save something you don't want to - I've seen it happen. I've also seen one person work all morning on a file only to have his PC freeze on him - he hadn't saved the file at all! He lost everything. Remember, "Save early and save often" - it works for me. -- Regards Andy Wiggins www.BygSoftware.com Home of "Save and BackUp", "Yogii" wrote in message ... I'm not very familiar with Excel but have a couple of files out of necessity. Recently, as I was working on one, there was some kind of error and it had to close down Excel. To prevent me from losing further information in the future I want to set an Autosave time limit but it's not on my PC - So I go to Help and it tries to tell me how to put Autosave in through Add-ins but it didn't like something on my MS Office disc SR-1 disc 1 and now when I try to do the Add-in it doesn't respond and I still can't get Autosave!!! Any help greatly appreciated! Frustrated! I realise something else might be wrong somewhere down the line and I hope to ask further questions later on but any help/ideas would be good for now... |
#3
|
|||
|
|||
autosave/add-ins
"Andy Wiggins" wrote ..
.... Remember, "Save early and save often" - it works for me. Subscribe to the above fully ... and a little extra, if I may .. "Save as well to a back-up copy at the end of each day .. " -- Rgds Max xl 97 --- Please respond in thread xdemechanik atyahoodotcom ---- |
#4
|
|||
|
|||
autosave/add-ins
I think I'd spend some time trying to figure out what's wrong with the CD--you
don't want to be left high and dry if you ever have to reinstall Office. But 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 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.) Yogii wrote: I'm not very familiar with Excel but have a couple of files out of necessity. Recently, as I was working on one, there was some kind of error and it had to close down Excel. To prevent me from losing further information in the future I want to set an Autosave time limit but it's not on my PC - So I go to Help and it tries to tell me how to put Autosave in through Add-ins but it didn't like something on my MS Office disc SR-1 disc 1 and now when I try to do the Add-in it doesn't respond and I still can't get Autosave!!! Any help greatly appreciated! Frustrated! I realise something else might be wrong somewhere down the line and I hope to ask further questions later on but any help/ideas would be good for now... -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|