Excel 2007 Copy and Paste Special (Not Responding)

[posadasd]

I have Excel 2007 SP2 and tried COPY and PASTE Special (VALUES) after a few seconds " NOT RESPONDING". the file contains 56,000 rows and 7 columns and file size 9MB. Tried moving from network location to local drive and did the same thing.

Tried using a lesser file size (1MB less) and it work
System:
Windows 7 SP1
4GB Memory
Dual Core 3GHz CPU

Please advise, I am just newbie on this forum.

Thanks

 

[posadasd]

Just wanted to add about this issue:

The issue occur when we select two columns but if we just do one, no problem

thanks