Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
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. ??? Last edited by KeithYardley : March 30th 12 at 06:42 PM |
#3
|
|||
|
|||
Quote:
Is it protected in any way? Sometimes this makes a difference. |
#4
|
|||
|
|||
I create a new workbook, and copy/paste within that workbook. If I save, it's a '.xlsx' file.
|
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
Quote:
|
#7
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
#9
|
|||
|
|||
Quote:
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 ! |
#10
|
|||
|
|||
THANKS JIM !!!
I read the link you suggested, hence uninstalled skype click to call and voilá !!! everything works again !!!! THANKS AGAIN !!!! YOU RULE !! |
#11
|
|||
|
|||
That was my problem as well. Skype updated recently... when I uninstalled Skype Click to Call, copy/paste worked normally again.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cntrl-end goes beyond end after rows have been deleted ? | Excel Discussion (Misc queries) | |||
cntrl+n wont work | Excel Discussion (Misc queries) | |||
cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
CNTRL + END is not working properly | Excel Worksheet Functions | |||
Cntrl + End (xlLastCell) | Excel Discussion (Misc queries) |