Excel 2003 data disappear
 

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.

Excel 2003 data disappear
 

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.

Excel 2003 data disappear
 

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.

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.

Excel 2003 data disappear
 

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

On Wed, 23 May 2007 16:29:00 -0700, Joe wrote:

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.

Excel 2003 data disappear
 

Thanks everyone for the tips. It should help. Thanks again.

"Gord Dibben" wrote:

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

On Wed, 23 May 2007 16:29:00 -0700, Joe wrote:

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.