PASTE SPECIAL - Paste Values vs Paste Unicode

[xterri]

There are times when PASTE SPECIAL opens up a window to allow pasting o
values/formulae/format/etc.

At times, going to the same EDIT/PASTE SPECIAL menu, opens up anothe
window asking only to paste UNICODE or TEXT, not showing the options o
values/formulae/format/etc.

See the pictures of the two distinct paste special windows.

Why am I getting this variation, and how can I always get th
values/formulae/format window?

Thanks


[image: http://mousaler.com/temp/paste_good.jpg]
[image: http://mousaler.com/temp/paste_bad.jpg

 

[Dave Peterson]

I didn't open your links.

But you usually get that "unicode/text" dialog when you're pasting between two
different instances of excel--not just two files open in the same instance.

If you don't like this, sometimes one of these works to stop the second instance
from opening:

Tools|Options|General|Ignore other applications (uncheck it)

--- or ---

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

There are times when PASTE SPECIAL opens up a window to allow pasting of
values/formulae/format/etc.

At times, going to the same EDIT/PASTE SPECIAL menu, opens up another
window asking only to paste UNICODE or TEXT, not showing the options of
values/formulae/format/etc.

See the pictures of the two distinct paste special windows.

Why am I getting this variation, and how can I always get the
values/formulae/format window?

Thanks

[image: http://mousaler.com/temp/paste_good.jpg]
[image: http://mousaler.com/temp/paste_bad.jpg]