none
Microsoft Excel cannot paste the data

    Pregunta

  • Hi,

    I have a user that is working on a Vista Terminal Server with Excel 2010 on it.  The user will copy a large amount of data in Excel 2010 and try to paste it into Excel 2010 on his local machine being Win 7 and Excel 2010.  Sometimes it works, for example if the terminal server has just been rebooted, but then most of the time Excel locks up and throws this error "Microsoft Excel cannot paste the data".  Has anyone ever had this problem and if so, have an answer for the problem?  Anyone have any suggestions?  Could it possibly be the clipboard?

    Any help is greatly appreciated.

    Thank You!

    miércoles, 02 de febrero de 2011 16:42

Todas las respuestas

  • Hi,

    Does your data have merged cells? If yes, that could be your problem. You cannot paste data from a merged cell range into a non-merged cells range. Both ranges have to be the same if a merged range
    is involved.

    Hope that helps.

    jueves, 03 de febrero de 2011 9:08
    Moderador
  • Hi, thank you for your reply.  The data does not contain merged cells.

    Thanks!

    jueves, 03 de febrero de 2011 15:24
  • Mine "didn't" either, but by selecting the data and choosing "unmerge cells" I was then able to copy.
    • Propuesto como respuesta BillSinc sábado, 05 de marzo de 2011 17:50
    miércoles, 02 de marzo de 2011 16:54
  • I tried choosing "unmerge cells" but was still unable to paste into a new document.  Any other suggestions?

    martes, 16 de agosto de 2011 19:52
  • I couldn't get it to work either.  Worked on some spreadsheets, but not others.  Could not find any pattern.  So I copied cells to the other spreadsheet and chose the Paste Link icon (one with the chain symbol).  Then where the newly pasted cells were, I did another copy and paste choosing the Paste Values icon (123 symbol).  Not the best fix, but worked for now.
    • Propuesto como respuesta LHarbin martes, 11 de octubre de 2011 22:54
    martes, 11 de octubre de 2011 22:53
  • I also have the same problems.  I tried LHarbin's way and it works! :) Thanks a lot!
    miércoles, 12 de octubre de 2011 0:09
  • I have just recently started to having this problem, it began October 21.  I have no merged cells but tried the unmerging anyway - that was not helpful in this situation.  But LHarbin's idea to copy and paste link was.  Thank you. 
    lunes, 24 de octubre de 2011 17:26
  • yep that chain symbol  link and 123 repaste works, the problem I believe is once the file is excel file is corrupted you need to do this, this happens to me from time to time and is not a continious problem
    jueves, 10 de noviembre de 2011 11:02
  • Someone in our office started having the same problem a few weeks ago as well

    It seems to depend on the spreadsheet.

    We'll try the 'unmerge'.

    jueves, 10 de noviembre de 2011 20:39
  • I had the same problem on my machine.  I discovered that it was being caused by a program, Macro Express, that was running in the background.  Once I disabled that program, the problem went away.  Try looking to see what you have running in the background and disable them one at a time.
    martes, 03 de enero de 2012 14:54
  • Paste Link icon (one with the chain symbol) works - thanks. But amending values (dates,currency etc) no joy. Cannot even change font size or colour of one cell. Message: "Too many different cell formats."  Tried paste special.  Don't know how to check for programs running in the background or where to find Macro Express. Please advise.
    • Propuesto como respuesta Owen Yeager martes, 03 de septiembre de 2013 22:30
    martes, 03 de enero de 2012 19:32
  • Hi LHarbin!

    Can You copy and paste cells with formulas this way?

    Renatoabc


    • Editado renatoabc jueves, 05 de enero de 2012 10:59
    jueves, 05 de enero de 2012 10:59
  • I had the same problem.

    Save the file, close Excel, and then open the file. I was able to copy/paste without errors.

    miércoles, 11 de enero de 2012 19:20
  • definitelynojoy--

    The "Too many different cell formats" can lead to a very unstable workbook. Try consolidating cell formats by using styles. Google the too many different cell formats, that's an ugly one in terms of making a workbook unstable.

    jueves, 08 de marzo de 2012 16:18
  • Maybe this will help,

    I had way too many TABs (Worksheets). After deleting few I was able to paste without a problem.

    jueves, 08 de marzo de 2012 20:40
  • 2 files I am working on are located on different servers. 

    After opening the second file into the same instance by going to File>Open seems to resolve the issue.

    Disregard the TABs previously mentioned.

    Thanks,

    Ravi

    lunes, 12 de marzo de 2012 18:23
  • http://support.microsoft.com/kb/213904 This should do it I gonna give it a shot.

    martes, 13 de marzo de 2012 19:39
  • i closed both files, and reopened, then it worked.
    martes, 10 de abril de 2012 21:42
  • I was having the same "cannot paste" problem. I was combining large amounts data from different sheets into one sheet. When I tried to copy 59000 rows into the sheet I started to get the error. I discovered that I was copying into an XLS excel sheet in compatibility mode. The problem is that using an xls sheet means that you have 65536 row maximum. I was trying to paste more rows into the sheet than is allowed. What I did was make sure to create a new worksheet(xlsx) and I copied in all the data I wanted with no problem. XLSX has up to a 1 million rows so you should be ok.
    • Propuesto como respuesta BadMadRad miércoles, 09 de mayo de 2012 18:30
    • Editado BadMadRad miércoles, 09 de mayo de 2012 18:30
    miércoles, 09 de mayo de 2012 18:29
  • When experiencing this issue, I found that by right-clicking to paste, I was given to option to have the copied data match the formatting of the destination sheet (see picture.) I had tried copying and pasting values, etc., but that did not work for me. This seems like the easiest solution, unless you are running into data limits as mentioned (xls versus xlsx.)

    • Propuesto como respuesta jlongjr martes, 08 de enero de 2013 19:53
    jueves, 13 de septiembre de 2012 17:05
  • I had a similar "Excel cannot paste the data" issue, but mine was with copying cells from one workbook to another on the same machine.  This was between two instances of Excel. It turns out pasting from one to the other copied all the Normal cell styles from one workbook to the other (I am assuming if the "Normal" cell style from the source workbook doesn't match the destination workbook's Excel creates a copy on the destination one).  As you copy back and forth the destination and source workbooks' style list grows exponentially.  By the end of it, there were thousands of "Normal 1", "Normal 1 2" etc. styles that needed to be deleted else they'd be copied from one to the other.  Since Excel maxes out at ~65,000 styles, once you get over 32,500 styles copying would ruin you if it tried to move all those styles. 

    I ended up running a macro that deleted all but the built-in styles and that resolved my problem. Macro is below.

    Sub StyleKill()
         Dim styT As Style
         Dim intRet As Integer
         On Error Resume Next
         For Each styT In ActiveWorkbook.Styles
             If Not styT.BuiltIn Then
                 If styT.Name <> "1" Then styT.Delete
             End If
         Next styT
     End Sub


    • Propuesto como respuesta Jfo316 jueves, 27 de septiembre de 2012 15:27
    • Editado Jfo316 jueves, 27 de septiembre de 2012 15:31
    jueves, 27 de septiembre de 2012 15:27
  • I tried saving and closing both files, re-opening, and was able to cut and paste.

    Thank you!

    lunes, 20 de mayo de 2013 18:07
  • I went to this link downloaded the fix tool and ran it on the file I was having the same issues as cannot paste and to many stles this removed these errors which was a build up over time of using the same sheet over and over monthly. once cleaned everything is working as it should.

    sergeig888.wordpress.com/2011/03/21/net4-0-version-of-the-xlstylestool-is-now-available

    martes, 03 de septiembre de 2013 22:31
  • Hello,

    I got it to work this way but it seems to have removed the format of the copy/pasted items into the spreadsheet. All items in the sheet should have the same format as they are a monthly run report. Any quick idea to correct the small data pasted with the format issue?

    Thanks

    jueves, 12 de septiembre de 2013 14:06
  • I was also facing the same problem.

    Your suggestion helped me to conclude.. Thanks!

    Only thing is I simply copied all the data from destination file (contained various styles) to a new file, ensure unnecessary styles not copied and it resolved the issue.

    It worked since the file did not contain any link or macro, otherwise the VBA code is the best solution. 

    viernes, 04 de octubre de 2013 11:56
  • Hi,

    I had a similar problem. Although I am not an expert at excel and this solution is probably basic, have you tried opening the source excel spreadsheet and the destination excel spreadsheet in the same window (namely open the source spreadsheet and then use the open function to open the destination spreadsheet). It works every time for me. Hope this helps.

    lunes, 13 de enero de 2014 21:15
  • The copy-paste link method works...thanks!

    martes, 14 de enero de 2014 14:47
  • This bug definitely needs to be raised back to Microsoft (hopefully someone here with a Microsoft Connect membership can do it?)

    I get this error occasionally when pasting into a spreadsheet, then can't paste that same data into any spreadsheet during the same Excel 'session', whether it's an existing or a new spreadsheet.

    However, if I close Excel and paste into a blank spreadsheet (without any modification to the clipboard between the closing of excel and re-starting of a new session), the paste works fine. From that new blank spreadsheet I then copy/paste to the final destination spreadsheet without any issues.

    It seems as though one of the spreadsheets that I open during the 'faulty' session, causes the paste function to fail. I am pasting a data range spanning >150,000 rows and nearly 40 columns.

    jueves, 16 de enero de 2014 0:34
  • This is what worked for me, as well, copying between servers. I do this every day copying into the same spreadsheet, and this doesn't happen often, but when it does, it's extremely frustrating.

    So thanks, Ravi.

    jueves, 06 de febrero de 2014 1:50