copy & paste problm

February 12, 2012 at 11:11:21
Specs: Windows 7, p 4 3.2ghz 1gb ram
Members: Please refer to Response #1, which is also from the OP, but contains a lot more detail.

Office Forum Moderator

Office Software Forum.Hi, I am using Excel 2007 The issue i face is while copying and paste to more than cells at a time. The process hangs. How can...

See More: copy & paste problm

Report •

February 13, 2012 at 07:08:49
Excel 2007, two separate worksheets. Copying a range of cell data (no formula) e.g. values from D2:D100 from one sheet to another, the paste results in blank cells (no data copied). This is often followed by Excel crashing.
I have tried using two separate instances of excel (separate monitors), one instance with both sheets open, same result.
I have tried resetting my PC, and only having excel running to ensure its not a memory problem (3.4GHz Intel with 3Gb ram) but this didn't help. I've also used a format cleaner to remove any superflouous formatting from the sheets - nothing seems to work.
Short of uninstalling and re-instaliing Excel I'm running out of ideas, can anyone offer any suggestions?

Report •

February 13, 2012 at 08:19:02
First thing to do is run a Diagnostic:

In 2007 to do a Diagnostic:

Running Microsoft Office Diagnostics from within Excel/Word

Click the Microsoft Office button
Click on the Excel/Word Options button to bring up the Excel Options dialog box (at the bottom of window)
Click on the Resources button in the left hand pane
Click on the Diagnose button in the right hand pane
Click Continue
Click Run Diagnostics


Report •
Related Solutions

Ask Question