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

K

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
 
S

Spencer101

KeithYardley;1600280 said:
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
 
A

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
 
A

Andres Dagotto

Andres said:
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
 
A

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 !
 
K

KeithYardley

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top