Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 30th 12, 04:01 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 5
Default 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   Report Post  
Old March 30th 12, 06:40 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 5
Default

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   Report Post  
Old March 30th 12, 06:52 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by KeithYardley View Post
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.
  #4   Report Post  
Old March 30th 12, 07:28 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 5
Default

Quote:
Originally Posted by Spencer101 View Post
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.
  #5   Report Post  
Old March 30th 12, 07:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 5
Default

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   Report Post  
Old March 30th 12, 07:48 PM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by KeithYardley View Post
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'
  #7   Report Post  
Old April 5th 12, 02:47 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 3
Default

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   Report Post  
Old April 5th 12, 03:33 PM posted to microsoft.public.excel.setup
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2008
Posts: 1,549
Default 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   Report Post  
Old April 5th 12, 04:17 PM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 3
Default

Quote:
Originally Posted by Andres Dagotto View Post
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 !
  #10   Report Post  
Old April 6th 12, 01:57 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2012
Posts: 3
Default

THANKS JIM !!!

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

THANKS AGAIN !!!! YOU RULE !!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cntrl-end goes beyond end after rows have been deleted ? Domrob Excel Discussion (Misc queries) 2 December 7th 06 05:09 PM
cntrl+n wont work JKC Excel Discussion (Misc queries) 4 June 15th 06 05:30 PM
cntrl + down arrow and null values in cells Craig Excel Discussion (Misc queries) 2 October 26th 05 10:23 PM
CNTRL + END is not working properly tgdavis Excel Worksheet Functions 1 August 11th 05 08:06 PM
Cntrl + End (xlLastCell) Bill Excel Discussion (Misc queries) 2 January 22nd 05 04:56 AM


All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright ©2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017