Re: Cntrl+C , Cntrl+V only does values...?

Spencer101

unread,

Mar 30, 2012, 1:52:51 PM3/30/12

to

KeithYardley;1600280 Wrote:
> Some additional info:
>
> I am using Excel 2007.
> I tried running in 'safe' mode. Same results, so it's not a macro
> (right?).
> Paste Special only gives me the option to paste as Unicode Text or Text.
> It's as if the formula was not copied... only the value got copied. So
> the problem is in the Copy operation (not the Paste operation).
> I get the same results using Cntrl+C, right-click the cell -> Copy, or
> the Copy/Paste buttons on the Home tab.
>
> ???

The file you're copying _from_, is it a .xls? .xlsx? .xlsm? .csv?
Is it protected in any way?

Sometimes this makes a difference.

--
Spencer101

KeithYardley

unread,

Mar 30, 2012, 11:01:57 AM3/30/12

to

Somehow I changed the default configuration of Excel...? On any cell
with a formula, I hit Cntrl+C. The cell does NOT get highlighted with
the dashed-line box around it.

If I hit Cntrl-V in a blank cell, I get the value, but not the formula.
Paste-Special is no better.

Any hints? Thanks!

--
KeithYardley

Jim Cone

unread,

Apr 5, 2012, 10:33:10 AM4/5/12

to

Andres,
See...
http://groups.google.com/group/microsoft.public.excel.misc/browse_thread/thread/0c6a3ff4324ba097?hl=en#

--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware .
(free and commercial excel programs)

"Andres Dagotto" <Andres.Dago...@excelbanter.com>
wrote in message
news:Andres.Dago...@excelbanter.com...
>
> Hi !
> I am having exactly the same problem ! Cntrl+C , Cntrl+V only paste
> values. If I try paste special, only unicode text or text are shown as
> possible values. Pasting to other applications only does text (and no
> longer images, metafiles, etc as it used to be).
>
> Perhaps I am having exactly the same situation Keith has, the only
> difference is I do not have any clue on how to trace but other program
> could be generating the mess hijacking the clipboard !
>
> Regards
> Andres
> --
> Andres Dagotto

Andres Dagotto

unread,

Apr 5, 2012, 11:17:40 AM4/5/12

to

Andres Dagotto;1600493 Wrote:
> Hi !
> I am having exactly the same problem ! Cntrl+C , Cntrl+V only paste
> values. If I try paste special, only unicode text or text are shown as
> possible values. Pasting to other applications only does text (and no
> longer images, metafiles, etc as it used to be).
>
> Perhaps I am having exactly the same situation Keith has, the only
> difference is I do not have any clue on how to trace but other program
> could be generating the mess hijacking the clipboard !
>
> Regards
> Andres

NEW UPDATE !!!! After manually turning off different programs I found
the problem is Internet Explorer ! If I turn it off, excel recovers all
its paste features !!!!

So, next question is what to do with IE settings !

--
Andres Dagotto

Andres Dagotto

unread,

Apr 5, 2012, 8:57:01 PM4/5/12

to

THANKS JIM !!!

I read the link you suggested, hence uninstalled skype click to call and
voilá !!! everything works again !!!!

THANKS AGAIN !!!! YOU RULE !!

--
Andres Dagotto

KeithYardley

unread,

Apr 9, 2012, 4:51:10 PM4/9/12

to

That was my problem as well. Skype updated recently... when I
uninstalled Skype Click to Call, copy/paste worked normally again.

--
KeithYardley