Normally copy/paste operations in Excel are pretty instantaneous. You copy data from one place and then paste into a cell in Excel. Pretty straightforward. But what do you do if you notice that copy/paste seems to take an excesseively long time when doing a paste in Excel? There are several things you can look for to resolve a situation like this.
1. If you are copying from a web page and pasting straight HTML into Excel there can sometimes be a delay during the paste operation. It depends on how much data you are pasting. the cause of the slowness is the formatting of the data itself. One thing you can do is paste the data into a notepad document , then copy and paste the data into Excel. This will strip out formatting and paste raw ASCII into Excel. Excel will then make a determination on the format of the data based on what gets pasted. You can also choose to Paste Special > Values into Excel which just pastes in the value of the data and none of the formatting.
2. Excessive amounts of custom styles can also cause the copy/paste to be slow. If you click on the Home tab in the Ribbon and look under Styles you will see a drop-down (see below pic) that when clicked will display all of your styles. Custom styles show up at the top and can be removed by right clicking the style and left clicking Delete.
3. Memory over-allocation is another cause of slow copy/paste. To check this, in your workbook hit the END button on your keyboard and then the HOME button. If your cursor drops down past the millionth row or to the last column this is an indication of memory over-allocation. To work around this problem you would need to remove all blank and unused rows and columns. After removal, click File > Save to save the changes to the workbook. This is necessary for the new memory allocation to take effect.
4. Finally, a large number of shapes, conditional formatting and pivot tables can also result in slow copy/paste behavior. If you have a large number of autoshapes or shapes in the workbook you can try removing a portion of these to see if the copy/paste time improves. A large number of conditional formatting can also cause slow copy/paste behavior. To check, click the 'Conditional Formatting' drop down under the Styles section of the Home tab and then click Manage Rules. This will open the Conditional Formatting rules manager. You can try deleting unused rules or removing a number of rules to test making the workbook more responsive. Lastly, a large number of pivot tables can cause copy/paste slowness. To work around that problem you can try moving a portion of your pivot tables to separate sheets or even other workbooks.
I found copy-paste very slow leading to hanging program [copying from adobe to excel in this case]. It is now fixed, and I think this link below is the fix that fixed it, which related to another problem of double clicking on desktop shortcut giving error that file was not found, but file could only be opened from within excel. This fix is to re-register excel in your system - www.naffziger.net/.../fix-error-when-double-clicking-an-excel-file-windows-cannot-find-the-file
I wonder what idiot even came up with the idea that when copying something you want the same formatting the place you insert it.
This functionality have been around for years, and every single time I've used it, I've had to click the little annoying arrow and select "Use the same format as destination"...
Regarding item 1, part of the delay in copying from an HTML page in Internet Explorer is caused by either IE or Excel accessing the internet to get a fresh version of the web page. This slowdown is noticable even on fast internet connections.
Excel is one of the worst programs ever full of stupid problem like you mentioned copy-paste...Unfortunately, there is no clear alternative.
I've noticed that if I use the keyboard shortcuts (ctrl+c or ctrl+v) there is a lag and excel freezes for about 2-3 seconds (just enough to irritate me). However, if I use the right-click copy and right-click paste method, there is no delay and it works instantaneously. I have no idea why this is but it would be great if this could be resolved. I prefer the keyboard shortcuts because its faster. I use excel everyday pretty much all day, so I lose a lot of time just waiting for it to respond.
Clearly the Paste with destination formats should have been the default paste option.
None of the 4 options above have solved the slow copy-paste problem I have (2-3 minutes per cell on a 16Gb RAM i7 Alienware !!)
Thanks for the advice re fixes for slow copy-paste. We use medium size spreadsheets that some times work fine and other times just crash at the slightest command. Have removed all the conditional formatting and fingers crossed seems to have done the trick.
However can you advise how to use conditional formatting so that the rules don't multiply?
File-option-Under General tab - Uncheck Enable live preview. This fixed all slow copy and paste issues for me.
Just a simple...! open new excel sheet copy all data from problematic sheet in new excel sheet and now save it. That's it..
I found the solution!!! (For me anyway) Go to File \ Options. Select the "Advanced" tab. Go to the "Cut, copy, and paste" section. Uncheck "Show Paste Options button when content is pasted" and "Show Insert Options buttons"
I had the problem of very slow copying of cells in Excel.
The cause was a program called PhaseExpress which kept a record of recent copies to clip board. I use PhaseExpress to enable me to have keyboard shortcuts to phrases I use regularly, like my email address.
I excluded Excel within PhaseExpress.
Copying in Excel is now instantaneous.
i have copied and pasted a worksheet several times but now when working on that sheet it is really slow. who do i delete everything including text boxes and still save spred sheet
Thanx Louis "works like a charm"