auto save freature

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi:

We are experinceing some difficulties with our use of the Excel program. we
use it to enter data in such a manner as to use it as scheduling program.
Several workbooks used as months, with mutiple worksheets for days. Two main
issues, one: we are unable to cut and paste from workbook to workbook, with
out the program crashing, and secondly: we use the auto save freature so as
we enter data, on a regualr basis, the data is saved. lately, we have ben
noticing that the "saved" data is either not there, or not in the original
place were it was entered.

We use 3 PC's, untder a shared document format to access the program, and
only one PC can save data to prime location using original file name.

The question, is has anybody seen this behavoir before and if so, is there
any "fix" to prevent data from being lost or "misplaced"?
 
If you're using Excel 2002 or newer, there is no Autosave as there was in
earlier versions.

Autorecovery from Tools>Options>Save 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 Dibben MS Excel MVP
 
Back
Top