Excel 2003 crashes when trying to copy/paste cells

[Guest]

This is a problem that I began having last week. When I copy cells in excel
and attempt to open a new email to paste it in, excel shuts down completely.
I have also attempted to copy cells from excel and paste into other Office
2003 programs and the same thing happens. Excel shuts down and if I have not
saved the file, everything is lost.

My IT department uninstalled and then reinstalled Office yesterday and the
problem stopped. Automatic updates ran today and installed the High Priority
updates and now the problem is back again. Is anyone else having this
problem and/or does someone know of a solution…?

Thanx...

 

[Guest]

I would like to know the same answer. I have a user in the office that has
the same EXACT problem. However, I have not gone to uninstall and then
reinstalling yet.

I would like to know the root cause to this if possible too. In the
meantime, I will see what I can dig up.

 

[Bob Flanagan]

Most likely there is corruption in the worksheet. Try doing a copy, paste
special, values to another worksheet, preferably one in another workbook.
If that works, corruption is most likely your problem. You may be able to
paste special formulas. I would not paste special formats, as that is where
I have seen corruption problems.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Guest]

OK - So how is the problem fixed?

Most likely there is corruption in the worksheet. Try doing a copy, paste
special, values to another worksheet, preferably one in another workbook.
If that works, corruption is most likely your problem. You may be able to
paste special formulas. I would not paste special formats, as that is where
I have seen corruption problems.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Guest]

This still has not been resolved yet, any answers?

 

[John Chabin]

I fixed this by going to Start|All Programs|Microsoft Office|(right-click Microsoft Office Excel 2003 & choose 'Troubleshoot compatibility'). I selected 'Try recommended settings' and Windows 7 recommended 'Windows compatibility mode: Windows XP (Service Pack 2)'. No more crashes when I copy multiple cells using ctrl-c!!!

 

[mmafan617]

We experienced the same issue here. I found it was related to Bluetooth believe it or not. Open the Registry in Regedit (go to run then type in Regedit). Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins Then find the LoadBehavior key and change it from 3 to 0. Once you reopen Excel it should work if the Bluetooth integration was the issue.

One other thing to check is to make sure you do not have any invalid network drives. If you have a disconnected network drive (you will find this in "My Computer" or "Computer"), this can also cause issues with Microsoft Office. Mostly this problem affects saving but a few machines seemed to have issues with random crashing when a bad network drive was found so it's worth checking into. If you do have any disconnected network drives, try removing them. This only applies to Windows 7 though.

 

[boumbh]

I fixed this by going to Start|All Programs|Microsoft Office|(right-click Microsoft Office Excel 2003 & choose 'Troubleshoot compatibility'). I selected 'Try recommended settings' and Windows 7 recommended 'Windows compatibility mode: Windows XP (Service Pack 2)'. No more crashes when I copy multiple cells using ctrl-c!!!

Oh my god ! I was having this problem for more than one year now ! I started to believe that Ms Excel 2003 inherited Ctrl-C from Ms DOS... But that was not it ! Ms Excel 2003 is just not compatible with Ms Windows 7 ! Thank you so much ! I won't have to retype every cell I want to duplicate any more ! Thanks John Chabin !



I may try the same technique on Ms Outlook, maybe I won't have to retype my password every five minutes... No... That is an other problem.

@mmafan617 My Bluetooth is activated, maybe your solution would have worked too, but I already spent too much time on this problem. I'll be back if it occurs again.

 

[boumbh]

Problem occurred again today ; applying solution of mmfan617 ; problem solved for now ; thanks mmfan617 ; hope I won't be back...