Excel 2003 data disappear

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

Guest

The windows auto update was set at daily 7:00am. During this time when I
highlight the entry from one spreadsheet and copy and paste to another
spreadsheet it will work but at some point the screen is back to the windows
desktop and the hightlighted data and the pasted data disappear. This does
not happen every morning but occassionally. Where did the data go to? I
can't find it anywhere. The spreadsheet is set to update every 2 minutes.
Hope someone can help.
 
Joe

Windows Auto Update has nothing to do with Excel but could interfere with
running programs while updates are being downloaded and installed, if there are
any...........which is unlikely every day.

How do you set the Excel workbook to "update" every 2 minutes?


Gord Dibben MS Excel MVP
 
The problem doen't happen every day. Maybe less than once a month. They set
the auto save by going to options and selection the auto save and setting it
to 2 minutes. They are using Excel 2003. I don't have this option in by
Excel 2000.
 
That is auto recovery saves, not for updating workbooks. A copy gets saved
in case Excel crashes. It doesn't save the file you are working on, you need
to do that manually.
 
Joe

If you're using Excel 2002 or 2003, there is no Autosave in XL2002 and 2003 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