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

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!

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.

I create a new workbook, and copy/paste within that workbook. If I save, it's a '.xlsx' file.

Ahhh.. solution!

Apparently I had another program running that was high-jacking the clipboard. The Cntrl+C operation was not allowed to copy the formula through some over-ride of the clipboard... I killed all the other non-standard things running and viola! It works.

Thanks for the prompting Spencer... I was looking at the excel file type when I saw the other apps running. Thanks for the help/response!

-K

Glad to have been of help mate, even if it was 'by proxy' :)

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

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

Andres,
See...
http://groups.google.com/group/micro...24ba097?hl=en#

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





"Andres Dagotto"
wrote in message
...

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

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 !

THANKS JIM !!!

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

THANKS AGAIN !!!! YOU RULE !!

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