If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Saving a spread sheet
I have a user who has a excel spreadsheet 0.5Mb. What they are trying to do
is copy & paste cells columns A to F (rows 1 to 1300) to G to L (rows 1 to 1300) . This copies fine, there are no filters, however there is a bit of formula but noting unusually out of the ordinary. So once the data has copied over they select save and get the following error message; "Excel.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being generated." Columns are from A to AO Rows from 1 to 1300 I have tried on another several other machines but the same error occurs. I suspect that this is a corrupt spreadsheet as others are ok. If this is a corrupt excel spreadsheet why do you think this may have happened and how to prevent it from happening again (also could not find anything on Technet on this - are there any articles)? If however it can be fixed please please let me know. Thanks in advance for you help \ suggestions James |
#2
|
|||
|
|||
I have in the past ran into this same type of error within my set of macro
codes dealing with production reports. The issue you are probably running into, which is the very same issue I ran into as I was running my reports, Excel by default has 16 undo levels. However, for those undo levels to take place, there has to be sufficient memory to be able to handle this. There's one other glitch of Excel with regards to the RAM usage. Excel 97/2000 will typically crash once it exceeds about 80MBs of RAM usage, just as Excel 2002/2003 will crash if it exceeds 160MBs of RAM, regardless how much RAM you have on your system. I had to go into the registry file and add in a new key, just as KB211922 indicates, and I set the undo level to 4. That was due to the fact that I had the code setup to copying a rather large amount of data, and then converted that range from formulaes to values, which after doing this to something like 15 different machine center workbooks via code, Excel had crashed on me after only doing 2 of them. However, once I added in this registry key to the system, Excel had quit crashing on me. Since that time, my production reporting program has been revamped and is using less and less in the way of formulaes as a lot of those formulaes has been converted to functions and procedures within VBA. Hope this is of help. Ronald R. Dodge, Jr. Master MOUS 2000 "James" wrote in message ... I have a user who has a excel spreadsheet 0.5Mb. What they are trying to do is copy & paste cells columns A to F (rows 1 to 1300) to G to L (rows 1 to 1300) . This copies fine, there are no filters, however there is a bit of formula but noting unusually out of the ordinary. So once the data has copied over they select save and get the following error message; "Excel.exe has generated errors and will be closed by windows. You will need to restart the program. An error log is being generated." Columns are from A to AO Rows from 1 to 1300 I have tried on another several other machines but the same error occurs. I suspect that this is a corrupt spreadsheet as others are ok. If this is a corrupt excel spreadsheet why do you think this may have happened and how to prevent it from happening again (also could not find anything on Technet on this - are there any articles)? If however it can be fixed please please let me know. Thanks in advance for you help \ suggestions James |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Setting up a spread sheet | jean | New Users | 1 | May 5th, 2005 07:54 PM |
Spread Sheet Tabs | George | Worksheet Functions | 9 | April 1st, 2005 07:02 PM |
how to use check boxes on a spread sheet | NAVY GIRL NEEDS YOU! | Database Design | 2 | November 9th, 2004 07:49 PM |
How do i create a drop-down calendar in an Excel Spread Sheet? | millerps | General Discussion | 2 | November 6th, 2004 01:39 PM |
Pub 02 saving excel sheet as picture | Jones | Publisher | 1 | August 25th, 2004 07:33 PM |