I have somehow changed my settings, I used to be able to get many options
when I clicked "past special", now I just get a dialogue box giving only two
options, either unicode text or text.

Also, when I right click a cell, and try to copy, it now adds multiple
entries to the office clipboard, the last one being "no preview available",
so a right click on a cell followed by copy, then a right click on another
cell followed by paste, will no longer copy the cell.

what have i changed?