|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.