Share via

microsoft excel cannot paste the data

Anonymous
2013-04-18T11:15:47+00:00

Hi,

I've read through the posts that are already refering to this error but none of them seem applicable.

I do not have Skype on my work PC and there are no merged cells

Basically up until yesterday I was able to copy and paste using Ctrl C and Ctrl V from one excel spreadsheet to another in different windows.

Since yesterday it has been saying cannot paste the data.

I rolled back the versions of the spreadsheets to the begining of the week when they were working fine but it's happening again. Also it sometimes works when I first open the sheet but then stops.

I did the cell styles count and for some reason both sheets (different completely) are showing the same about of styles 62043?

May be relevant - it's also asking me if I want to update date sources when I open now?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

10 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-09-10T15:38:36+00:00

    This may not be the solution in your case but it was in mine:

    I was getting the same error message.

    Tried everything here and nothing worked.

    Realized I had the 2 files open in separate excel windows (I had 2 instances of Excel running).

    Closed one and re-opened it in the same Excel window as the other one.

    Copy and pasted without a problem.

    50+ people found this answer helpful.
    0 comments
  2. Anonymous
    2014-09-25T01:08:00+00:00

    Hi

    Error:

    I tried opening a new sheet and then copy and paste into the sheet, but get this error:

    and the only formatting is colour.

    I have had my laptop re-imaged and still no good.

    My work around is to right click and paste special, as text and that allows me to paste. but loose the colour formatting

    Just to add to this I have found that even Cutting lines and pasting in the same sheet, it is picking up on values in other lines and inserting lines is doing funny things as well, pasting data form other lines raqther than just inserting blank lines!

    Thanks,

    Gus :)

    Hello Angus,

    Welcome to Microsoft Community and thank you for posting your query.

    What happens when you try to copy the content to a different Excel sheet?

    Do you receive any error message?

    Provide us the screen shot of the error message if you receive any to check and help you better.

    Thank you.

    7 people found this answer helpful.
    0 comments
  3. Anonymous
    2013-04-18T11:20:45+00:00

    Hi, do you see the word Enable where the formula bar is, if yes click on it

    5 people found this answer helpful.
    0 comments
  4. Anonymous
    2014-09-24T09:23:55+00:00

    Hello Angus,

    Welcome to Microsoft Community and thank you for posting your query.

    What happens when you try to copy the content to a different Excel sheet?

    Do you receive any error message?

    Provide us the screen shot of the error message if you receive any to check and help you better.

    Thank you.

    3 people found this answer helpful.
    0 comments
  5. Anonymous
    2013-04-22T10:14:46+00:00

    Hi Jeremy,

    Do you face this issue with a specific Excel file?

    If yes, you may copy the content of the file to a new Excel file and verify the status.

    If the issue occurs with all Excel file you may start the application in safe and check if it works fine:

    Click Start, type ‘excel /safe’ without quotes in search program and files and hit enter.

    Note: There is a space between the word ‘Excel’ and forward slash.

    3 people found this answer helpful.
    0 comments