Copy not functioning (not a Paste issue) - Excel 2007

[slipperybeans]

All of a sudden, when I try to copy a cell, no formulas get put into th
buffer; only values. The second I hit Copy or Ctrl-C, th
hash/highlight on the cell no longer appears. Also, the Paste Specia
options are much different, in that a different dialog comes up withou
the typical list. It is now a large text area with Unicode Text and an
Text as the only two options

This IS NOT an issue with Manual calculations being turned on
This IS NOT an issue with the Format of the cells being something lik
Text

I have rebooted, restarted, and even opened old files that never ha
this issue

So, I assume some setting has been updated without me knowing

The version is Excel 2007, and the OS is Win 7

Any help that avoids reinstalling Excel would be much appreciated

 

[Jim Cone]

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

 

[zaf]

slipperybeans wrote on 04/03/2012 11:15 ET

All of a sudden, when I try to copy a cell, no formulas get put into t
buffer; only values. The second I hit Copy or Ctrl-C, t
hash/highlight on the cell no longer appears. Also, the Paste Speci
options are much different, in that a different dialog comes up witho
the typical list. It is now a large text area with Unicode Text and a
Text as the only two option

This IS NOT an issue with Manual calculations being turned o
This IS NOT an issue with the Format of the cells being something li
Tex

I have rebooted, restarted, and even opened old files that never h
this issu

So, I assume some setting has been updated without me knowin

The version is Excel 2007, and the OS is Win

Any help that avoids reinstalling Excel would be much appreciate


slipperybean

I am having exactly the same problem on my desktop computer with Excel 7. Th
problem started about a week ago and prior to that the Copy/Paste/Paste Specia
command was working fine

It is also curious that I do not have the same problem with the Excel 200
installed on my laptop even with the same spreadsheet. So I am guessing tha
i
has something to do with having inadvertently changed some setting on th
desktop version of Excel 2007

Any help with this problem will be greatly appreciated.