Re: Excel drives me nuts
That's because it's not using the clipboard in the way you think it is. If you want to copy something and have it persist in the 'normal' clipboard, highlight it in the formula bar and then copy.
The excel copy mode is dynamic, so you can copy a cell or range, paste elsewhere, then allow something to update the values in the existing copy range and then paste these new and different values again, all without having to re-copy the original range. Magic.