Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 crashing - turn off autorecover?
My office just recently converted to Excel 2003 (from 97) - and it seems that
it crashes way more than 2000 or 97. In fact, sometimes I now open files in 97 and save with 97 to make the Excel files smaller and it seems to help out the crashing issue as well. And then autorecover always takes over and it just gets in the way. I am in the habit of saving anything I want to keep before running anything, so it's just an additional step. I've turned autorecover off - but it appears that there is also an autorecover associated with the workbook or something - but it still seems to go into autorecovery mode. I am a programmer and work exclusively with VBA (mostly Excel) - but it seems that other people at my office are having similar experiences (with 2003 crashing more), and they work with spreadsheets without any VBA. And autorecover mode just confuses the issue. Is there a way to disable autorecover altogether? And why are the files so much bigger? I'm keeping 97 on my machine just to fix this problem and to compress files. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 crashing - turn off autorecover?
I've turned autorecover off - but it appears that there is also an
autorecover associated with the workbook or something - but it still seems to go into autorecovery mode. I've turned it off too, by unchecking the "Save AutoRecovery..." box, and it's stayed off, not saving a recovery workbook, etc. So you're seeing that a recovery workbook is being saved to the Autorecovery save location despite the feature being turned off? I haven't seen much more crashing in Excel 2003 but I have seen the file shrinking you mentioned when saving in Excel 2000 (I don't use 97). I think though that that is mostly because the VB project becomes uncompiled. If you ran the code (in all the modules) I think you'd see the size come back to a large extent. One thing I've seen that you haven't mentioned is that macros run slower by a factor of about 1.6 in 20333 versus 2000. -- Jim "Ken Valenti" wrote in message ... | My office just recently converted to Excel 2003 (from 97) - and it seems that | it crashes way more than 2000 or 97. In fact, sometimes I now open files in | 97 and save with 97 to make the Excel files smaller and it seems to help out | the crashing issue as well. | | And then autorecover always takes over and it just gets in the way. I am in | the habit of saving anything I want to keep before running anything, so it's | just an additional step. I've turned autorecover off - but it appears that | there is also an autorecover associated with the workbook or something - but | it still seems to go into autorecovery mode. | | I am a programmer and work exclusively with VBA (mostly Excel) - but it | seems that other people at my office are having similar experiences (with | 2003 crashing more), and they work with spreadsheets without any VBA. And | autorecover mode just confuses the issue. | | Is there a way to disable autorecover altogether? And why are the files so | much bigger? I'm keeping 97 on my machine just to fix this problem and to | compress files. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2003 crashing - turn off autorecover?
I have a macro I just wrote that runs in 5 seconds in Excel 97 and takes
almost 5 minutes ( 4 minutes 50 seconds) in Excel 2003. "Jim Rech" wrote: I've turned autorecover off - but it appears that there is also an autorecover associated with the workbook or something - but it still seems to go into autorecovery mode. I've turned it off too, by unchecking the "Save AutoRecovery..." box, and it's stayed off, not saving a recovery workbook, etc. So you're seeing that a recovery workbook is being saved to the Autorecovery save location despite the feature being turned off? I haven't seen much more crashing in Excel 2003 but I have seen the file shrinking you mentioned when saving in Excel 2000 (I don't use 97). I think though that that is mostly because the VB project becomes uncompiled. If you ran the code (in all the modules) I think you'd see the size come back to a large extent. One thing I've seen that you haven't mentioned is that macros run slower by a factor of about 1.6 in 20333 versus 2000. -- Jim "Ken Valenti" wrote in message ... | My office just recently converted to Excel 2003 (from 97) - and it seems that | it crashes way more than 2000 or 97. In fact, sometimes I now open files in | 97 and save with 97 to make the Excel files smaller and it seems to help out | the crashing issue as well. | | And then autorecover always takes over and it just gets in the way. I am in | the habit of saving anything I want to keep before running anything, so it's | just an additional step. I've turned autorecover off - but it appears that | there is also an autorecover associated with the workbook or something - but | it still seems to go into autorecovery mode. | | I am a programmer and work exclusively with VBA (mostly Excel) - but it | seems that other people at my office are having similar experiences (with | 2003 crashing more), and they work with spreadsheets without any VBA. And | autorecover mode just confuses the issue. | | Is there a way to disable autorecover altogether? And why are the files so | much bigger? I'm keeping 97 on my machine just to fix this problem and to | compress files. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Crashing Weekly | Setting up and Configuration of Excel | |||
Visual Basic module from Excel 2003 crashing in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2003 crashing everytime user goes to save document. | Setting up and Configuration of Excel | |||
Can I use autosave in excel 2003 instead of autorecover? | Excel Discussion (Misc queries) | |||
Excel 2003 keeps crashing | Excel Discussion (Misc queries) |