Hello,

just recently I been receiving receiving error message "Microsoft Excel Cannot Paste The Data" when copying and pasting cells form one workbook to another, after that it's no longer possible to copy and paste between workbooks. It works fine between Excel and Word, but not within Excel. After the error I must save my work, turn off all Excel workbooks and begin again.

I have been doing this copying with exactly same workbooks and in exactly the same way for a few moths now, but suddenly can no longer do it. Nothing was changed in the workbooks.

The text I'm copying is just a string of text and there are no formatting and no formulas, no merged cells, no special or foreign characters, just raw text, in one cell. Both workbooks opened in the same window. In other words, just ordinary copying between workbooks.

Do you have any idea on what can be causing it? Maybe some update bug?

Best regards,

John

Hi,

This issue may be caused by some factors. Please try the methods below.

Method one:

Clean all the items in the clipboard manager and shut down it.

Quote from (We can see the last reply of this thread):

https://social.technet.microsoft.com/Forums/office/en-US/00d4d8e0-5413-46de-82d7-42880329796b/microsoft-excel-cannot-paste-the-data?forum=excel

Method Two:

 Ignore DDE

• Click the File tab, and then click Options.
• Click Advanced, and then click to clear the Ignore other applications check box in the General area.
• Click OK.

Hope it's helpful.

Regards,

George Zhao
TechNet Community Support