Some actions in Excel will clear the clipboard after you have copied or cut.
Two common ones are
- inserting a new sheet
- clearing a filter – using Clear in the Data menu (keyboard shortcut Alt a c )
So if you are going to do either of these, do them before copying or cutting.
LOL WORST HELP EVER. TELL EXCEL TO FIX THIS BUG. CLEARING A FILTER SHOULDN’T CLEAR YOUR CLIPBOARD.
Sorry sometimes you just have to work with what you have got.