View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default How do I Paste Special?

Chances are you are copying and pasting between 2 instances of Excel. Close
one workbook and then close that instance of XL. Reopen the workbook in your
remaining instance of XL and all should be well again...
--
HTH...

Jim Thomlinson


"Deb Kleb" wrote:

For some reason, when I try to Copy, then Paste Special -- Values, I am
getting a box that asks if I want Unicode Text or Text. I have done the
Paste Special -- Values command a thousand times successfully, and have never
seen this annoying box. No matter which of the items I check here, the next
thing I get is a message saying the data on the clipboard are not the same
size and shape as the selected area and asks if I want to paste anyway. Of
course I do because it IS the same size and shape. But I'm not allowed to do
that either.

What's up with Excel today??? I'm trying to get a report out!

Thanks,