Have to copy and paste twice to get all paste options

[superskid]

Not sure what is going on, but if I copy data from one workbook to another (same excel instance) The first time I copy the data I can only paste it as text only, if I choose paste special it comes up asking if I want unicode.

So I go ahead an paste it text only, then I copy the EXACT same data again, but this time when I paste it I can paste special it.

Any ideas? Very annoying to have to do it all twice.

Thanks in advance

 

[mole999]

you have to do that with things like colours and formats to work, just the way it sort of works

 

[superskid]

Never used to. Like if I copied a bold piece of text it would copy it bold. Now it just pastes the text the first time, then I do the exact same Control C Control V and it pastes it normal.