Excel 2010 removes data from clipboard, how can I stop it?

4

  • The order of my actions is:
    1. Copy data from pivot table from second sheet.
    2. Paste data as value into first sheet.
    3. Notice that something is wrong in the data.
    4. Go back to the second sheet and change data.
    5. Copy data from changed data.
    6. Return to first sheet.
    7. Select and delete wrong data.
    8. Try to paste new copied data from second sheet but clipboard is empty.

Why does Excel remove data from the clipboard when I select and delete data from a sheet? How can I change this strange behavior?

Raf

Posted 2013-05-14T16:31:39.927

Reputation: 51

Question was closed 2014-07-25T01:58:13.540

1That is normal behavior in Excel. Delete the wrong data first then copy and paste. Or just paste over the wrong data. – CharlieRB – 2013-05-14T16:38:47.227

1@CharlieRB: IMNSHO, that’s an answer.  Why don’t you post it as such? – Scott – 2013-05-14T17:01:37.090

Typing into a cell after copying, applying formatting to a cell and sometimes opening a new workbook empty the clipboard as well. – Jerry – 2013-05-14T17:12:09.190

Answers

2

What you describe is normal behavior in Excel.

Simply rearrange the order of how you are doing things should help. For instance, delete the wrong data first then copy and paste. Or just paste over the wrong data.

You can also use the Office Clipboard to save up to 24 items to reuse - Copy and paste multiple items by using the Office Clipboard

enter image description here

CharlieRB

Posted 2013-05-14T16:31:39.927

Reputation: 21 303

I think is not normal behavior, I make some tests. On the image http://i.imgur.com/HtdGjFb.png 1- new sheet 2- input some text 3- copy text to clipboard 4 - delete text from sheet but clipboard is not empty. Try to paste (Ctrl+V) text from clipboard, but nothing happens. If click button <Paste All> from Clipboard panel, magically (Ctrl+V) starts to work. Can you test this actions on your computer?

– Raf – 2013-05-15T17:14:02.003

Yes, that is normal behavior. Using keyboard shortcuts marks the selection, then copies the selection as soon as you tell it where you want to paste it. If you do anything else, it cancels the operation. I don't think it actually puts it on the clipboard unless you have the clipboard window open. – CharlieRB – 2013-05-15T18:18:11.903

Asked: 2013-05-14T16:31:39.927

Viewed: 3 501 times

Active: 2014-07-24T18:21:49.003