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

[KeithYardley]

Somehow I changed the default configuration of Excel...? On any cel
with a formula, I hit Cntrl+C. The cell does NOT get highlighted wit
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

 

[Spencer101]

Some additional info:

I am using Excel 2007.
I tried running in 'safe' mode. Same results, so it's not a macr
(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. S
the problem is in the Copy operation (not the Paste operation).
I get the same results using Cntrl+C, right-click the cell -> Copy, o
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

 

[Andres Dagotto]

Hi !
I am having exactly the same problem ! Cntrl+C , Cntrl+V only past
values. If I try paste special, only unicode text or text are shown a
possible values. Pasting to other applications only does text (and n
longer images, metafiles, etc as it used to be).

Perhaps I am having exactly the same situation Keith has, the onl
difference is I do not have any clue on how to trace but other progra
could be generating the mess hijacking the clipboard !

Regards
Andre

 

[Jim Cone]

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

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





"Andres Dagotto" <[email protected]>
wrote in message
news:[email protected]...

 

[Andres Dagotto]

Hi !
I am having exactly the same problem ! Cntrl+C , Cntrl+V only past
values. If I try paste special, only unicode text or text are shown a
possible values. Pasting to other applications only does text (and n
longer images, metafiles, etc as it used to be).

Perhaps I am having exactly the same situation Keith has, the onl
difference is I do not have any clue on how to trace but other progra
could be generating the mess hijacking the clipboard !

Regards
Andres

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

So, next question is what to do with IE settings

 

[Andres Dagotto]

THANKS JIM !!!

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

THANKS AGAIN !!!! YOU RULE !

 

[KeithYardley]

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