Excel freezes (goes into not responding) for 30-60 secs every time I do a copy and a paste

Lo0n

New Member
Joined
Dec 1, 2012
Messages
7
Hi,

I have a few spreadsheets specifically that hangs up my excel for about 30-60 secs every time I do a copy/cut and hangs again when I paste. It goes into "not responding" for a period of time and then resumes as per normal. The time it freezes is the same no matter how many cells I copy, it can be 3 cells or 3000 cells and it will still hang up for that certain amount of time.

Opening a new spreadsheet or some older less complicated spreadsheets do not have this problem and they work fine. This is specific to just several of the more recent spreadsheets I am working on. I have created a copy of the problematic spreadsheets on a new workbook to no avail as well.

Thanks in advance for any help guys. I am at such a lost, this is really stopping me from doing any work.

I am using MS OFFICE PRO PLUS 2010
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top