autosave/add-ins

[Guest]

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...

 

[Andy Wiggins]

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",

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...

 

[Max]

..
....

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 .. "

 

[Dave Peterson]

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.)

 

[Guest]

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...