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

Question

• 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?

Answer 1

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