Hi

Not always the case.
I have recently started to experience this in both Xl2003 and XL2007.
The usual culprit is having 2 instances of Excel open at the same time.

I get it happening when I have a single instance of Excel running, (checked
through task manager to ensure there is a single instance of Excel.exe), and
I have yet to find what causes it to happen.

It is happening at the moment for me.
If I close Excel and start again, then it is usually OK, but will
(randomly?) misbehave again.
I have searched Google and found not found a solution yet.

--
Regards
Roger Govier

"Sheeloo" wrote in message
...
The choices you get depend on what you have copied.

Usually if you copy from an Excel sheet you get all the choices. If you
copy
outside Excel then you get choices like 'paste as unicode', 'paste as
HTML',... etc.

"Steven D" wrote:

I often have to copy information to a new excel sheet and keep the column
length. When trying to use the Paste Special function I sometimes get a
page
with paste as Unicode Text or Text, sometimes I get a few more choices (I
think one of them is picture) and sometimes I get (what I want) where I
have
many choices of what/how I want to copy which includes a radio button for
columns (I think it also includes rows, formulas and other useful
things).

Why do I get different things and what can I do to get the page with the
many radio buttons?
--
Steven D