I am entering data into an excel workbook, is there a way to have the data
saved every minuite or some alloted time?

go to Tools, Options, Save and set you Auto Recovery time to what you want.

"Leonard" wrote:

I am entering data into an excel workbook, is there a way to have the data
saved every minuite or some alloted time?

xl2002+ has something called autorecovery. It's not the same as autosave, but
will allow you to recover files if excel/windows crashes.

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

Jan Karel's version will know if there was a crash and prompt you to open the
last version it saved.

===
And 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

Leonard wrote:

I am entering data into an excel workbook, is there a way to have the data
saved every minuite or some alloted time?

--

Dave Peterson