Excel 2007, Copy/Paste problem between worksh

February 4, 2011 at 06:52:18
Specs: Windows XP, 3.4GHz(3Gb Ram)
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?

See More: Excel 2007, Copy/Paste problem between worksh

February 4, 2011 at 07:53:52
Does this happen with all worksheets or just a specific one?

If it's a specific file, try it on a different machine (but expect a crash)

If it's a specific file, try copying a smaller range, like D2:D50, then D51:D100. If it crashes with one section but not the other, narrow it down even farther (e.g. D2:D25).

I've narrowed down worksheet corruption to a single cell by using this method.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question