I bet you're copying from one workbook to another.

And I bet you have two instances of excel running.

Try closing one of the workbooks, then in the first instance, do File|Open to
open that other workbook.

Now try your copy|paste special and see if it works.



rickf wrote:

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?

--

Dave Peterson