How do I get around error "Microsoft Excel cannot paste the data."?

KeysCShell Teller 1 Reputation point
2020-08-07T15:31:31.05+00:00

I'm trying to copy data from one excel file into another and I keep getting an error: Microsoft Excel cannot paste the data.

How can I fix this?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,715 questions
{count} votes

2 answers

Sort by: Most helpful
  1. MotoX80 33,481 Reputation points
    2020-08-07T21:52:41.097+00:00

    What are the contents of the cells? Do you have a link to external data? Do a simple test. In the source sheet, select a cell and just type in a few numbers. Then copy and paste that cell into the destination sheet. Does that work? Then select a row of the source sheet and try to copy that. See if you can identify which cell or cells is causing your problem. You can also try the "paste special" dialog and just paste the values to see if that works.

    0 comments No comments

  2. Emi Zhang-MSFT 24,986 Reputation points Microsoft Vendor
    2020-08-10T08:18:03.807+00:00

    Did the data you want to paste contain any merged cells? What version of Office did you use? Did this problem appear in all Excel Workbooks? Please be a bit more precise to explain your problem or you can upload a screenshot so that I can get more accurate solutions to this problem.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.