Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is my copy of Excel corrupt?
I have 10 sheets in my workbook. One sheet is constantly crashing and causing Excel to close while saving a copy for Microsoft. The sheet crashes when I copy a row and then use the Insert Copied Cells command to add a row. I have the same problem when I use the Insert Rows command. I only have this problem with one sheet. I can successfully add rows to the other sheets without any problems. Has any body else ever had this problem with Excel? Do I have a corrupt copy of Excel? Could any add-ins or formulas cause this problem? Excel 2002 SP3. Windows 2000 Version 5 SP4. Regards, -- Kent ------------------------------------------------------------------------ Kent's Profile: http://www.excelforum.com/member.php...fo&userid=5339 View this thread: http://www.excelforum.com/showthread...hreadid=379510 |
#2
|
|||
|
|||
Could be....
I'd try opening excel in safe mode. close excel windows start button|Run excel /safe file|open your workbook does it have problems then? More things to check... Maybe it's the file that holds the toolbar customizations that's damaged. Close excel windows start button|search (or find) *.xlb (Look for hidden files in hidden folders, too) Rename all of them to *.xlbOLD. Start excel normally and see if it works ok. If yes, then dump those *.xlbOLD files and customize your toolbar at your leisure. If there's still problems, then close excel and rename the *.xlbOLD files back to *.xlb (no harm, no foul!). And one more thing, close excel and clean up your windows Temp folder. Windows start button|Run %temp% is a quick way to get there. If you want to read more... Chip Pearson has some notes on how to diagnose startup errors at: http://www.cpearson.com/excel/StartupErrors.htm And Jan Karel Pieterse has more notes at: http://www.jkp-ads.com/Articles/StartupProblems.htm ======== Maybe opening and saving in openoffice would help fix it. (http://www.openoffice.org, a 60-65 meg download or a CD) If the file is really important, there are commercial recovery services. I've never used it, but you might want to check into: http://www.officerecovery.com Kent wrote: I have 10 sheets in my workbook. One sheet is constantly crashing and causing Excel to close while saving a copy for Microsoft. The sheet crashes when I copy a row and then use the Insert Copied Cells command to add a row. I have the same problem when I use the Insert Rows command. I only have this problem with one sheet. I can successfully add rows to the other sheets without any problems. Has any body else ever had this problem with Excel? Do I have a corrupt copy of Excel? Could any add-ins or formulas cause this problem? Excel 2002 SP3. Windows 2000 Version 5 SP4. Regards, -- Kent ------------------------------------------------------------------------ Kent's Profile: http://www.excelforum.com/member.php...fo&userid=5339 View this thread: http://www.excelforum.com/showthread...hreadid=379510 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is my copy of Excel corrupt?
I mayself have just experienced this EXACT problem. I have also duplicated the problem on different machines running separate copies of Excel (Win XP Pro). I have furhter isolated my case to ONLY when I COPY the top row of ablock of contmnous cells and want to INSERT COPIED CELLS below the top row of that group. Any row beneath the top row works fine. So still not solution. ..............Carl easton -- carleaston ------------------------------------------------------------------------ carleaston's Profile: http://www.excelforum.com/member.php...o&userid=32965 View this thread: http://www.excelforum.com/showthread...hreadid=379510 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
EXCEL Won't Print More Than One Copy | Excel Discussion (Misc queries) | |||
Copy row, Insert>Copied>Cells crashes Excel | Excel Discussion (Misc queries) | |||
How do I copy a Word text file into Excel in a way that each char. | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into excel? | Excel Discussion (Misc queries) | |||
How can I save an editable copy of a protected excel workbook? | Excel Discussion (Misc queries) |