Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data labels disappear | Charts and Charting in Excel | |||
Excel 2003 text disappear | Excel Discussion (Misc queries) | |||
EXCEL 2003 - LINES DRAWN ON CHART DISAPPEAR - WILL NOT STAY VISABL | Excel Discussion (Misc queries) | |||
My colours in the palette disappear at time when using Excel 2003 | Excel Discussion (Misc queries) | |||
In excel 2003, the menu bar and all toolbars disappear | Excel Discussion (Misc queries) |