View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Excel 2003 data disappear

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.

--
Regards,

Peo Sjoblom


"Joe" wrote in message
...
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.

"Gord Dibben" wrote:

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

On Wed, 23 May 2007 08:59:06 -0700, Joe
wrote:

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.